Card Visual to only display months selected -

[JayTG123]

Hi all,

I am looking for a way to display only the months selected via a slicer in the title header as per the below screenshots:

The formula I have at the moment was done via quick measure but for some reason at the moment the card is displaying April, August, December - when the month filter is set to all months currenrtly? It works if I then select a month or multiple but I dont want to see the three months that are listed currently. 

Many thanks
Jay

[Greg_Deckler · Accepted solution]

@JayTG123 You can add a VAR to get ALL of the months like

VAR __AllMonthsCount = COUNTROWS(DISTINCT(ALL('* Month Table'[Month)))

Then you can add an IF statement where if your two counts are equal to one another, just return BLANK because no months have been selected.