Forum Discussion

emilne's avatar
emilne
Frequent Visitor
2 years ago
Solved

Map Colour-Coded by Category

I have a table that contains the total number of items assigned to a label (see below) and I am trying to create a shape map that fills in each location based on the label with the maximum. (So for t...
Need Help
  • emilne's avatar
    emilne
    2 years ago

    Thanks, I wanted to apply the color to the legend so it would calculate the max value no matter which categories were selected. I was able to solve it filtering the visual on the measure Ranking==1: 

     
    RankTotal = SUM('Census'[Total])
    Ranking = RANKX(ALL('Census'[Label]), [RankTotal])
     
emilne's avatar
emilne
Frequent Visitor
2 years ago

Thanks, I wanted to apply the color to the legend so it would calculate the max value no matter which categories were selected. I was able to solve it filtering the visual on the measure Ranking==1: 

 
RankTotal = SUM('Census'[Total])
Ranking = RANKX(ALL('Census'[Label]), [RankTotal])