PDF export - need a title with text and start and end period of Data

[bilingual]

Hi, in my report i need to add the start and end period of Data, for example "March 2023 - September 2023", i need to use Min and Max on Date, but what can of field do i need to use?

[v-yiruan-msft · Accepted solution]

Hi @bilingual ,

You can create a measure as below:

Measure =
VAR _mindate =
    CALCULATE ( MIN ( 'Table'[Date] ), ALLSELECTED ( 'Table' ) )
VAR _maxdate =
    CALCULATE ( MAX ( 'Table'[Date] ), ALLSELECTED ( 'Table' ) )
RETURN
    FORMAT ( _mindate, "mmmm YYYY" ) & " - "
        & FORMAT ( _maxdate, "mmmm YYYY" )

Then use this measure as a dynamic title for your visuals. To do this, select the visual, go to the Format pane, enable Title, click on the three dots next to the title text, and select Conditional formatting. In the dialog box that appears, select the measure you created for your title.

Expression-based titles in Power BI Desktop - Power BI | Microsoft Learn

Best Regards