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 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!

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.

4 Replies

  • 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.

  • selimovd's avatar
    selimovd
    Most Valuable Professional
    5 years ago

    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
     
    • selimovd's avatar
      selimovd
      Most Valuable Professional
      5 years ago

      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