Custom line chart that supports two legends

[chiru_kudupudi]

Hello Everyone,

Is there any custom visual available to display two legends in a line chart?

I don't want to increase my dataset size as per the below solution. Any solution within the chart level is much appreciated.

https://community.powerbi.com/t5/Desktop/Custom-Visualisation-for-multiple-legends-and-values/m-p/64...

Thanks

[chiru_kudupudi · Accepted solution]

I have developed a column chart with conditional formatting based on my other column using rules.
For each item in another column (Which I want to keep in the legend to change colour of a line) corresponding to the y axis column provided a rule to change colour.
Then changed the column chart to a line chart and created the measures to keep in the value section to satisfy the legend section requirement to get separate lines.

[selimovd]

Hey @chiru_kudupudi ,

there is the option of a secondary axis for a few visuals:

Combo chart in Power BI - Power BI | Microsoft Docs

I think the best it goes with a column and line chart. Check out the link above.

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic