Dynamic title from filter selection

[MCacc]

Hello, 

I need to create a measure for a title to be put on a visual. 

The titel shows the values selected from a filter. 

The filter to be used is a Date format, a year to be exact.

The title should work in the following way:

- If the user selects one year, the title shows the year selected:

       2022 selected --> 2022 in the title

- If the user selected two years, the filter shows two years:

      2022 and 2023 selected --> 2022 and 2023 in the title

- If the user selects more than two years, they wanna see the MINIMUM and MAXIMUM year selected:

      2022, 2023, 2024, 2025 selected --> 2022 and 2025 in the title

Any idea how to achieve this?

Thank you very much

[v-jianboli-msft]

Hi @MCacc ,

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or if you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file after removing sensitive data.

Refer to:

How to provide sample data in the Power BI Forum

How to Get Your Question Answered Quickly

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Bifinity_75 · Accepted solution]

Hi @MCacc , try this:

- Create this measure:

Max_date = 
VAR MaxValue =
    CALCULATE ( MAX( Table1[Date].[Año] ), ALL(Table1[Date].[Año]))
RETURN
    CONCATENATEX (
        FILTER ( Table1, Table1[Date].[Año] = MaxValue ),
        MaxValue,
        " - "
    )

- Create this measure:

Min_date = 
VAR MinValue =
    CALCULATE ( MIN ( Table1[Date].[Año] ), ALL(Table1[Date].[Año]))
RETURN
    CONCATENATEX (
        FILTER ( Table1, Table1[Date].[Año] = MinValue ),
        MinValue,
        " - "
    )

- And last measure:

Result Selection = 
Var _count= COUNTROWS(VALUES(Table1[Date]))
return
IF (_count>2,[Min_date] & " - " & [Max_date], 
    CONCATENATEX(Table1,Table1[Date].[Año],"-")
    )

- The result:

I hope works it for you, best regards

[MCacc]

Thank you!!