I have a stacked column chart with some data and I have a pie chart with the same data. What I want to do is that if I click on one of the x-axis values on the stack column chart the pi chart should filter the data based on that data point. This is what my data looks like.
What I want on the image above is to click on Site3 and have the pie chart show the Type data only for site 3. However, when I try to do that the data ends up looking like this.
Is there a way to accomplish what I described without using a slicer?
For clarity these are my data points.
For Stacked Chart - Axis: Site, Legend: Type, Value: Volume
For pie chart: Legend: Type, Value: Volume
Solved! Go to Solution.
Click on a chart. And then click on format tab and Edit interactions.
On all other charts, you will see options have filter, highlight or stop filter.
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.
My Recent Blog - https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601
Click on a chart. And then click on format tab and Edit interactions.
On all other charts, you will see options have filter, highlight or stop filter.
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.
My Recent Blog - https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601
Thanks. That's what I was looking for
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Mark your calendars and join us on Thursday, June 30 at 11a PDT for a great session with Ted Pattison!
User | Count |
---|---|
210 | |
68 | |
63 | |
58 | |
56 |
User | Count |
---|---|
251 | |
196 | |
88 | |
72 | |
71 |