Forum Discussion

emilne's avatar
emilne
Frequent Visitor
1 year 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
    1 year 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])
     
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi, emilne 

After reading through your requirements, I'm sorry to say that it wasn't possible to determine what effect you ultimately want to achieve, whether you want to apply the color to the legend or the background color or something else. What do you mean by dynamic legend effect? Thanks for your understanding.

Best Regards,
Yang
Community Support Team