Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |