Forum Discussion
Legend in Line chart with two axis
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.
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.