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 ...
Need Help
  • 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.

      • Power_BI_2110's avatar
        Power_BI_2110
        Regular Visitor
        4 years ago

        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.