Hide Card when value is 0?

[Anonymous]

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!

[Greg_Deckler]

@Anonymous Add something like this to your measure

Measure
 VAR = __Value = <some calculation>
RETURN
  IF(__Value = 0,BLANK(),__Value)

[Anonymous]

Hi,

It gives me Blank and not hiding the card. (Refer Image Below).

[PhilipTreacy · Accepted 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

[Anonymous]

Hi,

I did the same as you mentioned. You mean there is no other way?  

[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

[Anonymous]

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. 😀