Display Several Months (Text) with Month Selection (Slicer)

[Anonymous]

Hello.

I have a measure that displays in a card visual the month selected in the Month slicer.

SelectMonth = IF(HASONEVALUE('Calendar'[Month]),FORMAT(SELECTEDVALUE ('Calendar'[Month]),"mmm",""))

e.g., when Feb is selected, card visual displays "Feb".

However, if more than one Month is selected, then the visual goes blank. See visual below.

So I tried to modify the DAX measure to accommodate more than 1 month .

However, it didn't work - still shows blank - pls see visual below.

Can you please help me modify this DAX measure so that if more than 1 month is selected, so that it will look like this:

"Dec, Jan, Feb" (example).

(Note: Month is in date/time format).

Thanks so much!

[Ashish_Mathur]

Hi,

This measure works

Measure = CONCATENATEX(VALUES('Calendar'[Month name]),'Calendar'[Month name],",")

Hope this helps.

[Anonymous]

Thanks Ashish.

Would you be kind enough to modify the DAX so that it will display as "Nov, Dec" instead of currently 11/1/2024. Thanks.

[Ashish_Mathur]

As you can see from the image that i posted, the result is Nov,Dec.

[Anonymous]

I see that, but I don't know why mine is showing as "11/1/2023, 12/1/2023" as you can see from snip. The format is "Text" but it shows up as date format. How can I correct this? Thanks so much Ashish.

[Ashish_Mathur · Accepted solution]

I am referring to the Month name of the Calendar Table which has text months.  The column that you are referring to in the CONCATENATEX() function may have date entries.  Check and correct for that.