Forum Discussion
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!
Thank you, I have resolved the problem by correcting my axis.
5 Replies
- AnonymousNot 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
Helper 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
Community 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
- AnonymousNot applicable
Hard to say without looking at the pbix file. Share the pbix file if possible. Also do accept my comment as solution