Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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

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

Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    7 years ago

    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

     

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Anonymous,

    You can change the filtering interaction between visuals here. 

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      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's avatar
        v-lili6-msft
        Icon for Community Support rankCommunity Support
        7 years ago

        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