Dynamic header

[Oros]

Hello,

I have a month selector, as well as a 'last x months' parameter selector.   

How do you show a dynamic title or header based on the selected month and selected last x months?

As examples in the image below, I would like to show the selected months (highlighted in yellow).  Thanks.

[danextian · Accepted solution]

hi @Oros 

You will need to use a disconnected table for the count of months to add and the selected months. Below is the sample formula I used to obtain the title in the table in the screenshot

Periods Included = 
VAR FilteredTable =
    FILTER (
        CALCULATETABLE (
            VALUES ( DatesTable[Date] ),
            DATESINPERIOD (
                DatesTable[Date],
                MAX ( DisconnectedDatesTable[Date] ),
                - [XPeriod Value],
                MONTH
            )
        ),
        DatesTable[Date]
            = CALCULATE ( EOMONTH ( MAX ( DatesTable[Date] ), -1 ) + 1 )
    )
VAR AddedColumns =
    ADDCOLUMNS ( FilteredTable, "@Month Name", FORMAT ( [Date], "mmm" ) )
RETURN
   CONCATENATEX ( AddedColumns, [@Month Name], ", ", [Date], ASC )

Please see the attached pbix.

[Oros]

Hi @danextian ,

Thank you very much for your quick reply.  You're a magician! 🙂