Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Anonymous
Not applicable

Dynamic title disappears if there's no data

Hi,

I have a measure like 

 

Dynamic_Title = "" & RIGHT(SELECTEDVALUE('Calendar'[Month_Year]), 4) & " change"
 
I use it as a dynamic title for my matrices.
It works fine if there's at least one row in the matrix. However, if there are none (or I filter it down to none), the title disappears. 
 
I tried 
 
IF(ISBLANK(SELECTEDVALUE = ...), "Alternative title", Dynamic_Title)
 
and switching title on/off. 
But it doesn't work. In addition, I don't really want an alternative title, I'd rather have my dynamic one fixed at all filters. 
2 REPLIES 2
jdbuchanan71
Super User
Super User

@Anonymous 

Are you able to share your .pbix?  I was not able to replicate the problem you are having.  Even when my matrix is empty the title measure still populates for me.

DynamicTitle.jpg

Anonymous
Not applicable

@jdbuchanan71 

Thank you for answering. 


I found the problem, though I don't quite understand the reason. 

It happened because I had a conditional formatting - color scale for my value. 

I changed it to rules and used numbers for intervals, the titles worked fine. 

However it didn't work for rules and percentages. 

 

So conditionfal formatting of the title is somehow connected to relative conditional formatting of the value. 

I don't know how to upload here, but I think it's quite easy to replicate 🙂 

 

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.