Forum Discussion
JayTG123
Advocate I
Advocate ICard Visual to only display months selected -
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 ...
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.
Greg_Deckler
Community Champion
Community ChampionJayTG123 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.