Legend in Line chart with two axis

[amitbisht51]

Hi,

I am using a line chart visual, the underlying data is using dax table.

In chart 'Value' field I have inserted a column with 100k range and 'Secondary value' field has data in percentage format.

Both these values are again a dax measure.

As you are aware, PowerBI doesnt allow me to add Legend field and it populates legend automatically in the visual.

In my case, the legend doesnt change when I use different slicers to see particular fields in 'Value'.

Does any one know, if I can add the legend using dax or through any other way so that my legend works properly?

Thanks!

[galaamri]

Hi @amitbisht51 

The Solution to go around this is by bookmarks and selection buttons or images. 

1- Create Identical chart but for %

2- switch the two views of charts by using bookmarks and buttons. Follow the link below to understand bookmarks and how to use them.
https://youtu.be/xCMqWEvSkAs

Good Luck. 

[MFelix]

Hi @amitbisht51 ,

A great Super User ( @parry2k ) made a blog post about that dinamic change of legend check it on the link below:

https://perytus.com/2021/02/04/improve-ux-show-year-in-legend-when-using-time-intelligence-measures/

[amitbisht51]

Hi @MFelix ,

I am able to create to legend using dax, but since I have values in secondary field also alongwith primary values, I am not able to add my legend.

Is it possible to add the legend in this case?

Thanks.

[MFelix]

Hi @amitbisht51 ,

If you use legend you cannot add the secondary values and vice-versa, in this case and since it's a line chart I would recommend the use of a disconnect table with the calculation details plus the secondary value.

For example if you need to have years and average of something you would need a similar table to this one:

Calculation

2018

2019

2020

2021

SecondaryValue

Then using a switch measure for each value.

If you need help to setup this can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.

If the information is sensitive please share it trough private message.

[Power_BI_2110]

Hi @MFelix 

I am facing a similar issue. Can you explain how to create a disconnected table with an example to solve this issue? 

Thanks.