Forum Discussion

F_Reh's avatar
F_Reh
Icon for Post Patron rankPost Patron
8 months ago
Solved

Dynamically changing Title to Latest Month

Good afternoon,   How do I make the title of a Visual Card to update each month dynamically. The measure is always automatically updated as each month passes, but the title I am having to update ma...
  • rohit1991's avatar
    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.

  • Zanqueta's avatar
    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 🌀.

  • Rufyda's avatar
    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