Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Dynamic title disappears if there's no data


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. 
Super User II
Super User II

Re: Dynamic title disappears if there's no data


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.


Frequent Visitor

Re: Dynamic title disappears if there's no data


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

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!


Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors