Forum Discussion
Dynamic Legends in Line chart
In my table I have Group, Subgroup, SubSubGroup, Date and Values
When doing a line chart (X = Date, Y = Values) I set as legend the Groups column and it displays X lines according the number of groups, but when filtering wether Group, Subgroup or SubSubGroup it shows me only one line.
So the question is, is it possible to change the Legend so when I apply the filters it shows me the same amount of lines of the corresponding subgroups...
Ex:
-When I dont apply Group filter, it shows the same number of lines than the amount of Groups
-When I apply a Group filter, it shows the same number of lines as the amount of Subgroups within the Group selected
-When I apply a Subgroup, filter it shows the same number of lines as the amount of SubSubGroups within the Subgroup selected.
Thanks in advance!
1 Reply
- amitchandakSuper User
Anonymous , Try if you can use field parameter in Legend and change that using a slicer
Power BI Field Parameters — A Quick way for Dynamic Visuals: https://amitchandak.medium.com/power-bi-field-parameters-a-quick-way-for-dynamic-visuals-fc4095ae9afd
Power BI Field Parameters- Measure Slicer and Axis/Dimension slicer: https://youtu.be/lqF3Wa1FllE