Line chart - multiple slizers, multiple legend

[Anonymous]

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

*Then I want to choose ADHD and Alle in the second slizer - so I get 4 lines in total: (Kvinder - ADHD), (Kvinder-Alle), (Mænd-ADHD) and (Mænd-Alle).

At the moment, I only get one for Women and one for Mand, and it just sum ADHD and Alle.  (I can only choose one variable in the legend)

Do anyone know if this is possible? if Not, does anyone have an good idea how to illustrate this?

Best

Sarah

[Anonymous]

Hi @Anonymous 

It can be done with the help of Perspective.

You need to have the August 2020 release and have Tabular Editor installed through Help --> External Tools

Here is the link to the steps.

https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-august-2020-feature-summary/#_Perspectives

[v-deddai1-msft]

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

[vanessafvg]

can you demonstrate in the visual what you are trying to achieve with an example?  you will probably need to create another calculated measure or potentially calculated measures for each line you want to plot.