Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Line chart - multiple slizers, multiple legend

Hi,   I want to create a line chart, where one can choose from multiple slizers and get a line for each option.   Example: * I want to choose both Mænd and Kvinder, and get a line for each *The...
Need Help
v-deddai1-msft's avatar
v-deddai1-msft
Community Support
6 years ago

Hi Anonymous ,

 

I'm afraid it's not able to use slicer to change legend dynamically based on checked column names from the slicer visual directly by power bi. As a workaround, I suggest you use drill down report: https://docs.microsoft.com/en-us/power-bi/consumer/end-user-drill

 

Or you can create a slicer table, use the UNION function to summarize the legends you want to slice. Apart from that slicer related value, all the rest of the values are blanks.

 

For more details, please refer to  https://prathy.com/2018/12/dynamic-legend-in-power-bi-visual-linechart/

 

Best Regards,

Dedmon Dai