Forum Discussion

9 Replies

  • molegris's avatar
    molegris
    Advocate IV
    5 years ago

    Hi,

    Just for those who are still struggling despite the advise to use CONVERT.  You might have done the same mistake I did.  CONVERT is not going to work alone... you need to change the type on the settings of the measure.  duh!  can't beleive I missed it!

    Actually, after changing the type in the settings part, I didn't even need to use the CONVERT function.

     

    regards,

    --mo

  • Gordonlilj's avatar
    Gordonlilj
    Solution Sage
    6 years ago

    Hi,

     

    What is the datatype for the measure?

    I belive measures used for titles must must be a string datatype for it to work

    • danextian's avatar
      danextian
      Super User
      6 years ago

      The measure is a string that shows a range of dates with this format: dd/mm/yy - dd/mm/yy.

  • jochenj's avatar
    jochenj
    Advocate III
    6 years ago

    i have the same issue: measure is visible but not selectable in the dialog of Title Expression 

    Tried with simplest possible measure without success:
    lblX = "My Custom Title"

     

    The only thing i can choose in this "Title Text" dialog are COLUMNS but not MEASURES 

    Any hints? 

    Thanks,

     

  • chahineatallah's avatar
    chahineatallah
    Helper III
    3 years ago

    I am having the same issue, am not able to select my measure to be used as title

    my measure gives a text ,tried also the convert but still no chance to work

     

    Title = var st= IF(HASONEVALUE('date'[Year]),
    IF(HASONEVALUE('date'[Month Name]),
    "",
    AVERAGEX(VALUES('date'[Month Name]),
    "Average workouts per month")))
    return
    CONVERT(st,STRING)
  • Bapollon's avatar
    Bapollon
    New Member
    1 year ago

    There is a simple solution

     

    Create another measure like, 

     

    "Chart Title = "Your Text " & [Your Measure]"

     

    and link it to the other measure you created before, it automatically selects text formats and can be set for conditional formatting.