Dynamic title to display multiple selected

[Anonymous]

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 year of the last twelve months, so report consumers can filter the data. 

I want a dynamic title which appears, if they apply this slicer. And shows all the months they have picked. 

I can do the measure for if they pick one month, but as soon as they pick two, it breaks. 

HELP!

[v-easonf-msft · Accepted solution]

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.

[selimovd]

Hey @Anonymous ,

can you post your measure?

This makes it easier to help you.

Did you put multiple values together with CONCATENATEX?

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

[selimovd]

Hey @Anonymous ,

I've seen you deleted the reply.

The reason there was that you used the FORMAT function on the already concatenated string.

So if the string looks like "01 20201, 02 2021, 03 2021" and you use the FORMAT function on it, it would not work because the format doesn't fit.

Does this solve your issue?

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi