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
6 Replies
- PhilipTreacy
Super User
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
- PhilipTreacy
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
- Greg_Deckler
Community Champion
Anonymous Add something like this to your measure
Measure VAR = __Value = <some calculation> RETURN IF(__Value = 0,BLANK(),__Value)
