Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello everyone,
I would like to know if there is any exisiting way of excluding a card from any existing filters.
Let me explain : In order for my numbers to fall right, I need to set a filter for the whole report/page excluding a category called "Other", but for a specific calculation, the "Other" category needs to be taken in account to get the right result.
Do you know any trick to avoid setting filter on each visualisation except the calculation I need ?
Thank you for your help,
Alexandre
Solved! Go to Solution.
Sure. There are a few ways to do this.
1) You could edit the slicer interactions. This way, slicers just don't apply. Unfortunately, it sounds like you have a page level filter, so you're more likely to have luck with #2.
2) You could change the calculation to specifically ignore filters. I don't know what your calculation is, but the general form would be something like this:
CardCalculation = CALCULATE( [MyCalculation], ALL('Data'[Category]))
This ignores all filters on the column [Category].
Without knowing the measure you're using for the card, I can't be any more specific than this. Hopefully it's helpful.
Sure. There are a few ways to do this.
1) You could edit the slicer interactions. This way, slicers just don't apply. Unfortunately, it sounds like you have a page level filter, so you're more likely to have luck with #2.
2) You could change the calculation to specifically ignore filters. I don't know what your calculation is, but the general form would be something like this:
CardCalculation = CALCULATE( [MyCalculation], ALL('Data'[Category]))
This ignores all filters on the column [Category].
Without knowing the measure you're using for the card, I can't be any more specific than this. Hopefully it's helpful.
I have a page filter yes, solution #2 worked perfectly thought, thanks a lot for your quick answer
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |