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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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