Change total volume of a chart based on selection

[Anonymous]

Hello all, I hope you can help me as I am struggling with the following...

I delivered a report, but I was asked if I could make an option to zoom in on an existing selection. In this case, the user wants to select a certain activity of a week and gain insight into which concerns are related to these activities. As such, I would like a breakdown in the shape of a pie chart that shows these concerns.

However, as you can see, the breakdown above is not very informative at all, as it is really difficult to draw a comparison from this. You can imagine it's even less accurate when the selection decreases further.

Is there a way to alter the total of the pie chart to the entire selection, so it becomes a more useful comparison? Like is there a way to filter it by selection in some sort of way?

Help would be greatly appreciated.

[kleigh]

Turn on Format > Edit Interactions

With one chart selected, the other one can be set to "Filter" rather than "Highlight"

[Anonymous · Accepted solution]

Hi @Anonymous ,

Please try the following methods and check if they can solve your problem:

1.create the sample table.

2.Create the drill through page and create the more visuals to filter. Drag the field into the drill through pane.

3.Select the category and drill through.

4.Select You can also view the following link.

Set up drillthrough in Power BI reports - Power BI | Microsoft Learn

Best Regards,

Wisdom Wu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Thank you, this pretty much worked. It opens in a new sheet, but it does give the requested information.

I found a YouTube video that also helped me further, but it had a LOT of ads.