cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

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

Re: Dynamic title disappears if there's no data

@alibek 

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

Highlighted
Frequent Visitor

Re: Dynamic title disappears if there's no data

@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
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!

secondImage

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