cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
bestmbaman Member
Member

Card visual disapear when data is not available

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

 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Card visual disapear when data is not available

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:

image.png

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:

image.png

 

Hopefully this is what you are looking for.

 

Regards,

Tom

 

Hamburg - Germany
If I answer you question, please mark my post as solution, this will also help others.
Proud to be a Datanaut!
3 REPLIES 3
Super User
Super User

Re: Card visual disapear when data is not available

Hey @bestmbaman ,

 

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 

Hamburg - Germany
If I answer you question, please mark my post as solution, this will also help others.
Proud to be a Datanaut!
bestmbaman Member
Member

Re: Card visual disapear when data is not available

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

Super User
Super User

Re: Card visual disapear when data is not available

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:

image.png

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:

image.png

 

Hopefully this is what you are looking for.

 

Regards,

Tom

 

Hamburg - Germany
If I answer you question, please mark my post as solution, this will also help others.
Proud to be a Datanaut!