Forum Discussion
How to insert a Header in Power BI?
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
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
3 Replies
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
