Forum Discussion

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.

    • Gordonlilj's avatar
      Gordonlilj
      Solution Sage
      6 years ago

      Could you post the entire measure?

      • danextian's avatar
        danextian
        Super User
        6 years ago

        I'm posting a different measure since the period range measure is dependent on othe pretty long measures. This one is pretty simple but still I can't select this as a visual title.

        P&L Overview text =
VAR __RANGE =
    SELECTEDVALUE ( 'Actual vs Benchmark Measures'[Range] )
VAR __BENCHMARK =
    SELECTEDVALUE ( 'Actual vs Benchmark Measures'[Benchmark] )
RETURN
    "P&L Overview " & __RANGE & " " & __BENCHMARK