how to show latest date as title in chart

[Anonymous]

HI I do have 

Name	Date
A	30/7/21
B	29/7/21
C	2/8/21
D	30/7/21

I do have one additional column (Format(Date),""mm-yyyy"). i just need to show latest date(2/8/21) as 2-Aug as Title on matrix or Stacked column chart. 

Pelase let me how to do. Heaps thanks in advance

[ibarrau · Accepted solution]

Hi. In order to change a title dynamically you can go under formatting options in a visualization. The title might have a small button next to the text like "fx". That one will let you configure a function like conditional formating. You can use a DAX Measure like:

Matrix Dynamic Title =
CONCATENATE(
    "Matrix until: ", FORMAT ( MAX (Tabla[Date]), "d-MMM-YYYY")
)

Once you have the measure just add it in the fx menu formatting by "field value" and selecting the measure.

You can read more about this here: https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-format-visual-titles

Don't forget to check the Limitations on the bottom.

I hope that helps,

[Anonymous]

HI Ibarrau. thanks for replying and support to clear this issue. it works. Heaps thanks