How to create a total card and disable drill through?

[sesame5486]

I want to have prominent total card on my dashboard showing total sales. I don't want the value to change when users select other elements on the report.

For example, I have a pie chart showing breakdown by region. How do I stop the drill through on the card, for example, when a user selects "NA".

I want the 52bn below to be fixed.

I don't want it to change to 33bn.

My data is very simple. I have a Sales table containing sales by product. I also have a product table that contains product attributes (e.g. region).

[DOLEARY85 · Accepted solution]

Hi,

click on the chart elemet on the report, click the format ribbon and select edit interations. You'll be able to turn off the changes from that chart on your total card by clicking the circle with the line through it:

You'll need to do this with any chart that interacts with the total.

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

[Adescrit]

1. Select your donut chart visual.
2. In the menu ribbon, go to the Format tab and click on "Edit Interactions".
3. Now with the donut chart still selected, hover your cursor over the card visual. In the top-right there will be a couple of new icons visible. Click on the one that looks like a stop sign and says "None". This now means that any interactions with the donut chart will not have any impact on the card visual.
   
   
   

[sesame5486]

That worked, thanks!