Forum Discussion
Dynamically changing Title to Latest Month
- 8 months ago
Hii F_Reh
You can make the title dynamic by using conditional formatting on the visual title. Create a DAX measure that returns the latest month text (for example using MAX on your date column), then go to Format >> Title >> fx, choose Field value, and select that measure. The card value will refresh automatically, and the title will update each month without manual changes.
- 8 months ago
Hi F_Reh
Create a measure for the dynamic title, assuming you have a calendar table.
For example, if you have a date table, you can use:
Dynamic Title =
"Performance for " & FORMAT(MAX('Calendar'[Date]), "MMMM YYYY")
Apply the measure to the visual title
Select the card visual → Format → Title → click the fx icon (conditional formatting).
Choose Field value and select the measure Dynamic Title.If this response was helpful in any way, I’d gladly accept a 👍much like the joy of seeing a DAX measure work first time without needing another FILTER.
Please mark it as the correct solution. It helps other community members find their way faster (and saves them from another endless loop 🌀.
- 8 months ago
Hi F_Reh
Create a measure:Dynamic Title =
"Performance for " &
FORMAT(MAX('Calendar'[Date]), "MMMM YYYY")
Apply it to the card title:Select the visual
Format → Title → fx
Field value → Dynamic Title
✔ Title updates automatically every month
Did it work? ✔ Give a Kudo • Mark as Solution – help others too!
Regards,
Rufyda Rahma | MIE
Hi F_Reh,
rohit1991 already mentioned how you can meet your requirements. A suitable measure could look like the following:
1) Assuming that you already have a month represented as text:
2) Assuming that you have a month reprensented as number: