Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Shape Map Advanced Filtering with cards & slicer

Hi, I’m new to this forum and would appreciate your help. I’ve built a report with a shape map, a dropdown slicer and several cards. The slicer allows to select a year and pressing a state shows va...
Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    7 years ago

    Hi Anonymous,

     

    I made one sample for your reference.

     

    We can create a measure as below to work on it.

     

    Measure = var _Catoosa = CALCULATE(SUM(Sheet1[Total]),FILTER(Sheet1,Sheet1[_State]= "Catoosa"))
return
IF(ISFILTERED(Sheet1[_State]),CALCULATE(SUM(Sheet1[Total])),_Catoosa)

     

     

     

     

     

    Regards,

    Frank

Anonymous's avatar
Anonymous
Not applicable
7 years ago

My approach to formating numbers in the card was all wrong. When using measures to fill a card, one must select the measure in the fields pane, and then go to format in visual tools and choose the format. Its quiete  simple yet took me a while to find out. Hope this will help others.