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,
Thank you for reaching out to the Microsoft Fabric Community Forum. Also, thanks to danextian, Rufyda, Zanqueta, Zanqueta, for those inputs on this thread.
Has your issue been resolved? If the response provided by the community members danextian, Rufyda, Zanqueta, Zanqueta, addressed your query, could you please confirm? It helps us ensure that the solutions provided are effective and beneficial for everyone.
Hope this helps clarify things and let me know what you find after giving these steps a try happy to help you investigate this further.
Thank you for using the Microsoft Community Forum.
Hi F_Reh,
Just wanted to follow up. If the shared guidance worked for you, that’s wonderful hopefully it also helps others looking for similar answers. If there’s anything else you'd like to explore or clarify, don’t hesitate to reach out.
Thank you.