Forum Discussion
Helper IILegend doesn't change when using dynamic measures in chart
Hi,
I have created a graph, that has 8 measures and that has a slicer, which is used for choosing the measure. I use CONTAIN in the body of measures for filtering (I tried also SWITCH but this works only for selection of one measure). Everything works well besides the legend that doesn't change with the displayed measures. Instead, it only shows all of them all the time. How can I please arrange that only selected measures show in the legend?
Thank you!
3 Replies
- amitchandak
Super User
michael163 , I doubt you can change the legend name as measure name. But you can change title name.
Refer this blog for that -https://radacad.com/change-the-column-or-measure-value-in-a-power-bi-visual-by-selection-of-the-slicer-parameter-table-pattern
Please provide your feedback comments and advice for new videos
Tutorial Series Dax Vs SQL Direct Query PBI Tips
Appreciate your Kudos.
michael163But I don't want to change the legend name, I dont want to have the legend name there at all (only the names of the measures). All I want is to be able to select more measures and the legend would show only those I selected.
For example here -> I have 6 measures in the graph. Then there is the slicer, where I can select "ARR" or "Clients". If I select ARR, as shown on the picture, I need legend to show only (3) measures that are in the graph. Not those that are for the selection hidden.
I did it according to this video where it works for the author: https://community.powerbi.com/t5/Webinars-and-Video-Gallery/Turn-Measures-On-and-Off-Inside-a-Chart-with-CONTAINS/m-p/151045.
- v-easonf-msft
Community Support
Hi, michael163
I'm sorry,I followed the tutorial to test, and it did not achieve the same effect as the author as well.
This video was published three years ago. Perhaps this is caused by the powerbi version.
You can try to contact the author to discuss if something is missing.
You can also submit your issue to the support team to investigate it.
My test result:
Best Regards,
Community Support Team _ Eason
