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'm having a bit trouble with combining a matrix and a pie chart. I have a set of data which tells me the status of a project per country. In the matrix visual, I've set a visual level filter on "bad" as the status. This indicates me which projects need attention. See examples.
Dataset:
Filter on the matrix
Pie chart
The problem I encounter is when I select a country in the matrix visual, the visual level filter from the matrix applies to the pie chart. For example, when I select USA, the pie chart will only show me the projects which are bad according to their status. See example.
For the pie chart, I want to see all the projects from USA (good and bad). For the matrix, I don't want anything to change. I've tried using variaties of measures with ALL and ALLEXCEPT, but I can't seem to figure it out. Does somebody know how I would fix this sort of problem?
Thanks in advance,
Lars
Solved! Go to Solution.
hi, @Anonymous
After my research, when you do an interaction between two or more visuals, the visual level filter will affect other visuals too. so you could try this way:
Don't set visual level filter on matrix visual and use a measure instead of "Count of Countries"
Measure = CALCULATE(COUNTA('Table'[Projects]),'Table'[Status]="Bad")
Then set "Count of Countries" for pie chart.
Result:
Best Regards,
Lin
hi, @Anonymous
You could use All Function to add a measrue
Measure = CALCULATE(COUNTA('Table'[Projects]),ALL('Table'[Countries]))
Result:
Here is pbix file, please try it.
Best Regards,
Lin
Hi Lin,
Thanks for your reply!
The formula works, but it isn't giving the result I desire.
When I filter on a country, the pie chart shows me a total of all the bad projects.
When I filter the matrix on a country (for example: USA), I want the pie chart to display all the projects which belong to the chosen country (2 good, 2 bad).
I feel like this isn't an extreme difficult task, but I can't seem to figure it out 😞
Thanks in advance!
Best regards,
Lars van de Bunt
hi, @Anonymous
After my research, when you do an interaction between two or more visuals, the visual level filter will affect other visuals too. so you could try this way:
Don't set visual level filter on matrix visual and use a measure instead of "Count of Countries"
Measure = CALCULATE(COUNTA('Table'[Projects]),'Table'[Status]="Bad")
Then set "Count of Countries" for pie chart.
Result:
Best Regards,
Lin
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 |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |