How to insert a Header in Power BI?

[vsmk]

Say the report is for the period 1st Apr to 10th Apr 2018.    The header should be

SALES REPORT AS ON 1st Apr 2018 to 10th Apr 2018

[Anonymous · Accepted solution]

@vsmk

If the date range is dynamic, create a measure which will have text + the date range.

Then use the Card visual as a header and put measure as a Field for the visual.

Example for measure definition -

HeaderMsg = "SALES REPORT AS ON " & FORMAT(MIN(table[field1]), "mmmm dd, yyyy hh:mm AM/PM") & " TO " & FORMAT(MAX(table[field1]), "mmmm dd, yyyy hh:mm AM/PM") 

)

Regards

[vsmk]

Thanks @Anonymous

[vsmk]

Say the report is for the period 1st Apr to 10th Apr 2018.    The header should be

SALES REPORT AS ON 1st Apr 2018 to 10th Apr 2018