Forum Discussion

amitbisht51's avatar
amitbisht51
Microsoft Employee
5 years ago

Legend in Line chart with two axis

 

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!

Need Help

5 Replies

    • amitbisht51's avatar
      amitbisht51
      Microsoft Employee
      5 years ago

      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's avatar
        MFelix
        Super User
        5 years ago

        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.

  • galaamri's avatar
    galaamri
    Helper I
    3 years ago

    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.