Ignoring a visual level filter from a matrix in a pie chart

[Anonymous]

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

Filter on matrix

Pie chart
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.

Selected value

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

[v-lili6-msft]

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

[Anonymous]

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

[v-lili6-msft · Accepted 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

[Anonymous]

@Anonymous,

You can change the filtering interaction between visuals here.