Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Dynamic title to display multiple selected

I know this has already been covered, and probably asked by me before, but I am finding multiple and confusing solutions which i'm not sure are what I need.  I have a date slicer holding month and y...
Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    5 years ago

    Hi, Anonymous 

    Could you tell me whether your problem have been solved?

    You can also try measure as below to create dynamic title:

    Selected Month = 
VAR selectedmonth =
    VALUES ( 'financials'[Date].[Month] )
RETURN
    "Sales by Month: "
        & IF (
            COUNTROWS ( selectedmonth ) = COUNTROWS ( ALL ( 'financials'[Date].[Month] ) ),
            "All",
            CONCATENATEX ( VALUES ( 'financials'[Date].[Month] ), 'financials'[Date].[Month], "," )
        )

     

     

    Please check my sample pbix file for more details.

    Best Regards,
    Community Support Team _ Eason
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-easonf-msft's avatar
v-easonf-msft
Community Support
5 years ago

Hi, Anonymous 

Could you tell me whether your problem have been solved?

You can also try measure as below to create dynamic title:

Selected Month = 
VAR selectedmonth =
    VALUES ( 'financials'[Date].[Month] )
RETURN
    "Sales by Month: "
        & IF (
            COUNTROWS ( selectedmonth ) = COUNTROWS ( ALL ( 'financials'[Date].[Month] ) ),
            "All",
            CONCATENATEX ( VALUES ( 'financials'[Date].[Month] ), 'financials'[Date].[Month], "," )
        )

 

 

Please check my sample pbix file for more details.

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Fusilier2's avatar
    Fusilier2
    Helper V
    1 year ago

    This worked for me!