Forum Discussion
Solved
Dynamic header
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.
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.
2 Replies
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.
