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.
Hi,
I've 3 cards shown below, I want to hide the cards when the value is "0". Is it possible? My User should not see the "0" resulted Cards. Pls help me on this. Thanks!
Solved! Go to Solution.
Hi @Anonymous
Sorry, this isn't possible.
However you can set up Conditional Formatting rules so that the value and category turn white (or the same colour as your background) effectivelymaking the card disappear.
Download this sample PBIX to see an example
Note that in that PBIX I've turned on the border on the card, just so you can find it. Turn it off to make the card 'invisible'.
Before Conditional Formatting
After Conditional Formatting
Regards
Phil
Proud to be a Super User!
@Anonymous Add something like this to your measure
Measure
VAR = __Value = <some calculation>
RETURN
IF(__Value = 0,BLANK(),__Value)
Hi,
It gives me Blank and not hiding the card. (Refer Image Below).
Hi @Anonymous
Sorry, this isn't possible.
However you can set up Conditional Formatting rules so that the value and category turn white (or the same colour as your background) effectivelymaking the card disappear.
Download this sample PBIX to see an example
Note that in that PBIX I've turned on the border on the card, just so you can find it. Turn it off to make the card 'invisible'.
Before Conditional Formatting
After Conditional Formatting
Regards
Phil
Proud to be a Super User!
Hi,
I did the same as you mentioned. You mean there is no other way?
@Anonymous
Correct. You can't remove a visual based on a value. Best you can do is hide the value and data label as I've shown.
Regards
Phil
Proud to be a Super User!
Thanks, my only concern here is I can't place one top of another for better UI looks. Always each Card occupies dedicated space. Anyway if there is no way then. I can accept your solution.
Mr.PowerBI Tool should include this feature ASAP. 😀
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 |
---|---|
114 | |
99 | |
82 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |