Forum Discussion

Userpath77's avatar
Userpath77
Icon for Helper II rankHelper II
5 years ago
Solved

Pie Chart not filtering stacked column chart

Hello All

 

I have a pie chart in which the vlaues are 3 Measures. The measures just look at dates in a table and group them by <30 Days, >30 Days, and >60 Days.

 

I have a Stacked Column Chart on the same page and using the same measures. The only difference is that the axis contains the different offices that all these dates apply to.

 

The problem is that when I click on any piece of the pie chart, it does not filter the Stacked Column Chart at all. Does anyone know what causes this and how to resolve?

 

Thanks!

  • Userpath77's avatar
    Userpath77
    5 years ago

    Thank you, I have resolved the problem by correcting my axis.

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    As I understand, the pie chart is divided into 3 buckets and count(probably) is being put in each bucket based on date condition. If you select a piece of pie chart why would it filter stacked column chart where axis does not contain same buckets ? 

    Let me know if my assumption is wrong. If yes, I would first check the interaction and data model for flaws. 

    If none of this works then do share the pbix file, if possible.

    • Userpath77's avatar
      Userpath77
      Icon for Helper II rankHelper II

      You are correct, just realized that is the problem. Do you know how I can add this office field (axis) to the pie chart so they are linked, but hide the office field in the Pie Chart display?

      • v-easonf-msft's avatar
        v-easonf-msft
        Icon for Community Support rankCommunity Support

        Hi,  Userpath77 

        Could you please tell me whether your problem has been solved?

        For now, there is no content of description in the thread.

        If you still need help, please share more details  for further research.

        Best Regards,
        Community Support Team _ Eason

         

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hard to say without looking at the pbix file. Share the pbix file if possible. Also do accept my comment as solution