cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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 your question, please mark my post as solution, this will also help others.
I accept Kudos :-), If you find my post helpful.

Proud to be a Datanaut!

View solution in original post

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 your question, please mark my post as solution, this will also help others.
I accept Kudos :-), If you find my post helpful.

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 your question, please mark my post as solution, this will also help others.
I accept Kudos :-), If you find my post helpful.

Proud to be a Datanaut!

View solution in original post

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)