Forum Discussion

MCacc's avatar
MCacc
Helper IV
3 years ago
Solved

Dynamic title from filter selection

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.   ...
Need Help
  • Bifinity_75's avatar
    Bifinity_75
    3 years ago

    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

     

     

     

v-jianboli-msft's avatar
v-jianboli-msft
Community Support
3 years ago

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.