Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I am trying to to make multiple graph where I want to compare numbers per Business Area with Group Numbers. When filtering I want to keep the group number (totals) and show the selected BA against Group.
When I try, I keep on getting all lines in my charts filtered as well and no lines for the total (Group).
Does anyone know how to solve this?
Thanks!
No, you can't fix the total row/group in chart when applying a filter. I suggest you create a measure to show total value with ALL() filter and put this measure into a Card visual.
Regards,
Hi @msin88,
It sounds like creating measures for each line you want to show and putting these into the Values bucket of the line chart may solve your problem...
@msin88 can you give a screen shot of the issue, i dont quite understand what your expectations are maybe if you can provide a visual of whats happening and how it should look
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |