Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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. 
Need Help

2 Replies

  • jdbuchanan71's avatar
    jdbuchanan71
    Icon for Super User rankSuper User
    6 years ago

    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.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      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 🙂