Line and Clustered Column Chart with Custom Tooltip for Power BI

Line and Clustered Column Chart with Custom Tooltip for Power BI


This visual is created from advance visual Dual Y-Axis Combo Chart



Steps to create Line and Clustered Column 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' and 'Units Sold' are mapped under Value 1, Value 2, Value 3 and Value 4 respectively.

Line and Clustered Column Chart with Custom Tooltip

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
e.g. - Here for Sales, COGS and Profit we have kept Bar. For Units Sold, it is Line.

Line and Clustered Column Chart with Custom Tooltip

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 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.

Line and Clustered Column Chart with Custom Tooltip

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’.

Line and Clustered Column Chart with Custom Tooltip