Dynamic text with the switch formula

[Nun]

Hello,

I have a table 

Month   City 

Jan         "Paris"

Feb         "Madrid"

Mar        "Berlin"

Apr        "Zurich"

Now I created a dynamic text with switch formula:

SWITCH(TRUE(), VALUES('Table[City]) = "Paris", "Paris - " & VALUES('Table'[Month]) & " " & YEAR(TODAY()),VALUES('Table[City]) = "Madrid", "Madrid - " & VALUES('Table'[Month]) & " " & YEAR(TODAY())...

The dinamyc text, if one month is selected, is: Paris - Jan 2022.

now I have a slicer with the months. If the user select one month, the dynamic text shows correctly the city, the month and the year.

If the user select more than a month, for example Jan and Feb, the dynamic text returns an error: " a table with multiple values...".

How can I change the switch formula considering that 1 or more month (text) can be selected?

Thanks!

[v-jayw-msft · Accepted solution]

Hi @Nun ,

You could use CONCATENATEX() function.

Measure = CONCATENATEX('Slicer','Slicer'[Column1],"-")

Best Regards,

Jay

[Nun]

Thanks Jay, I solved the issue creating a measure with

CONCATENATEX. A measure which contains a double concatenatex (one for the city and one for the month) & 

YEAR(TODAY()) (to get the year)...in this way I can get the correct city and correct month when the user uses the filters City and Month.

Br.

[Shreeram04]

Hi @Nun 

Try a Quick Measure called "Concatenated list of values".

Thanks

[Nun]

Hi @Shreeram04 , thanks for your quick reply. I tested it, unfortunately the concatenated list of values doesn't  fully satisfy my need.

Thank you!