Weird Dynamic Button Text Issue

[dbrandone]

So I have 4 buttons set up for page navigation within a report. 2 of the pages are Current Year Data and another is "Last Month". Instead of having Static text for the buttons as "Current Year" and "Last Month", I wanted the buttons to be dynamic with the text. I wrote the measures as:

Last Month Button Text =

     Calculate(
             Values('Date'[Month Name]),
             'Date'[Month Offset] = -1
           )

Current Year Button Text =

      Calculate(

              Values('Date'[Year]),

               'Date'[Year Offset] = 0

          )

The Last Month measure is not greyed out and works perfectly in the Button and shows November. The issue is the Current Year button as the measure is greyed out in the field value drop down. I have tried different measures for the current year, but all still have the measure greyed out and un-selectable. I have tried "Max" instead of "Values".

Does anyone know what could be causing this. I have made sure that the columns being filtered or used are in the correct format.

[ebeery]

Hi @dbrandone, it appears from my testing that only Text columns/measures can be returned as button text.  In your case, "Month Name" is a text value, while "Year" is likely numeric.

You could try either converting Year to Text, or wrapping your "Current Year Button Text" in a FORMAT function like below:

Current Year Button Text =
FORMAT (
    CALCULATE ( VALUES ( 'Date'[Year] ), 'Date'[Year Offset] = 0 ),
    "General Number"
)