Forum Discussion

Nun's avatar
Nun
Resolver I
4 years ago
Solved

Dynamic text with the switch formula

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

    Hi Nun ,

     

    You could use CONCATENATEX() function.

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

     

    Best Regards,

    Jay

4 Replies

    • Nun's avatar
      Nun
      Resolver I
      4 years ago

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

      Thank you!

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Nun ,

     

    You could use CONCATENATEX() function.

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

     

    Best Regards,

    Jay

    • Nun's avatar
      Nun
      Resolver I
      3 years ago

      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.