Create Line, Clustered Column and Scatter Chart with Custom Tooltip for Power BI
This visual is created from advance visual Dual Y-Axis Combo Chart
Steps to create Line, Clustered Column and Scatter Chart from Dual Y-Axis Combo Chart
Step 1. Map your data in the fields available
Here ‘Country’ is mapped under Category. ‘Sales’, ‘COGS’, 'Profit', 'Units Sold' and 'Discounts' are mapped under Value 1, Value 2, Value 3, Value 4 and Value 5 respectively.
Step 2. Choose the Series Type
Go to Format Visual tab. Under ‘Value 1’, ‘Value 2’ and ‘Value 3’ section Series Type will be Bar. For ‘Value 4’ make Series Type as Line and for ‘Value 5’ make it as Scatter
e.g. - Here for Sales, COGS and Profit we have kept Bar. It is Line for Units Sold and Scatter for Discounts.
Step 3. Select the Axis Type
In case you want to show the data in secondary axis you can select Secondary under Y axis.
e.g. - for Value 1,2 and 3, we have selected Primary for Y axis and for Value 4 and 5 Secondary for Y axis.
Please note, values which are bound to Primary X axis will appear behind to the values plotted on Secondary X axis.
Step 4. Format your visual further
You can further format your visual like color, size, opacity of your series, labels, legend etc under the same tab ‘Format Visual’.