Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
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
Hope it resolves your issue? Did I answer your question? Mark my post as a solution! Appreciate your Kudos, Press the thumbs up button!! Linkedin Profile |
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
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.
Proud to be a Super User!