Welcome to deBUG.to Community where you can ask questions and receive answers from Microsoft MVPs and other experts in our community.
1 like 0 dislike
in Power BI by 26 30 35
edited by

I have a report with many visuals in Power BI, one of these cards is visual with the total and I need to Stop filtering for this card when I click on other charts, How can I restrict the card visual from NOT filtering in Power BI?

1 Answer

1 like 0 dislike
by 154 174 350
selected by
Best answer

Ignore Slicer Filter in Power BI

To restrict the card visual from NOT filtering in Power BI, you have to use the awesome Edit Interactions option in the Format Tab.

edit interaction power bi

How to use Edit Interactions in Power BI

  1. In Power BI Desktop, Click on "Format" tab.
  2. Click on "Edit Interactions".
  3. Click on the visual that you would like to ignore the filter when clicking on it.
  4. On the Card visual, click on "Filter" icon to ignore the filter when you click on the selected visual.
    No Filter in Power BI
  5. Click again on "Edit Interactions" button to apply the filter settings.
  6. Try now to use the selected visual to filter other visuals, you will note that the Card visual is not filtered as expected.

    Read more at How to ignore Slicer Filter in Power BI?

by 26 30 35
0 0
This a great option, thanks for your usual help
If you don’t ask, the answer is always NO!