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

Removing title of a visual when data is blank or N/A

Hi,

I have couple of visuals(gauges, Tachometer, advanced cards, matrix, etc.) in my Dashboard and the problem is that when I don't have data, although the data lables removed, I can't remove the titles of the visuals?

What is the DAX formula for this purpose?

Many thanks for your ideas

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Removing title of a visual when data is blank or N/A

You will need to use the new conditional formatting titles along with a measure to check for your value being blank.  Something like.

 

IF ( ISBLANK ( [value measure] ), "", "This is my title")

 

I use the "" instead of BLANK() to return and empty string instead of (BLANK)

 

You then use this measure in the conditional format title of your visual.

https://docs.microsoft.com/en-us/power-bi/desktop-conditional-format-visual-titles

View solution in original post

1 REPLY 1
Super User
Super User

Re: Removing title of a visual when data is blank or N/A

You will need to use the new conditional formatting titles along with a measure to check for your value being blank.  Something like.

 

IF ( ISBLANK ( [value measure] ), "", "This is my title")

 

I use the "" instead of BLANK() to return and empty string instead of (BLANK)

 

You then use this measure in the conditional format title of your visual.

https://docs.microsoft.com/en-us/power-bi/desktop-conditional-format-visual-titles

View solution in original post

Helpful resources

Announcements
October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 122 members 1,595 guests
Please welcome our newest community members: