Forum Discussion
Hide Card when value is 0?
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!
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
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).