Card visual disapear when data is not available

[Anonymous]

Hi,

I need to use a card visual (or similar) with in my Tachometer gauge. when data is N/A Tacho gauge disapears automatically but the cards I placed inside them just show Blank. now, my question is:

How I can get rid of card visuals inatead of showing Blank? The current issue with them is that even when I remove the data lables when Blank, I can not remove the Titles of my Card. What is the DAX formula for it?

P.s. I also used Advanced Card visual but still impossible to remove titles.

Many thanks dear supporters

[TomMartens]

Hey @Anonymous ,

at the current moment Power BI does not support to "show / hide" a visual based on a measure value.

For this reason, you can try to set the fill color and data label to the same color as the background. Please be aware, that then you will have a blind spot on your report page.

Hopefully this provides some additional ideas.

Regards,

Tom 

[Anonymous]

Thanks @TomMartens ,

I don't get it, my question was about how to hide the title of the tachometer visual when the data is N/A. I don't concern the data label. Please advise a good solution.

Thanks again

[TomMartens · Accepted solution]

Hey,

I'm referring to the title of this thread.

You can use a measure (you have to use the latest version of Power BI - June 2019 releaese), that returns an empty string when anoter measure is blank. Create a measure like so:

vizAid Card Title (no title when measure is blank) = 
var theValue = [Total Quantity]
return
IF(ISBLANK(theValue) , "" , "The amount is " & theValue)

Then you can assign this measure to return the text, this text will be used as title:

Please be aware, that you have to come to close to the region of upper arrow to make "3 little dots" appear, using these dots, you can enter the conditional formatting.

From this dialog you can select the measure from the table it is assigned to:

Hopefully this is what you are looking for.

Regards,

Tom