Forum Discussion

JayTG123's avatar
JayTG123
Icon for Advocate I rankAdvocate I
4 years ago
Solved

Card 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 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

 

 

 

 

Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    4 years ago

    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.

1 Reply

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    4 years ago

    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.