Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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!
@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
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 38 | |
| 36 | |
| 33 | |
| 33 | |
| 29 |
| User | Count |
|---|---|
| 134 | |
| 96 | |
| 78 | |
| 67 | |
| 65 |