Forum Discussion

ineedham's avatar
ineedham
Icon for Helper I rankHelper I
10 years ago

Filled State Map's Diverging Color Scales with Slicer

I’m trying to create a filled map/choropleth with a category slicer controlling three distinct maps with diverging color scales. I’ve created a filled map based on state salary data with three salar...
Need Help
Tutorial Requests
Eric_Zhang's avatar
Eric_Zhang
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago
ineedham wrote:

Thank you, Eric,

 

I removed Category from the Legend.  

 

My issue is still that I don't know how to create a different diverging color scale for each of the 3 categories in the slicer (I'm not even sure it's possible).  Setting the diverging color scale applies to all categories, which is a problem for my data because the annual salary data values are much larger than the hourly and per visit values.

 

 

ineedham

Based on my test, to get a different diverging color scale, you may have to use 3 individual filled maps, with the color saturation filled by measures as below. A slicer is not necessary in this case.

HourlySal = CALCULATE(MAX(Table[Salary]),Table[Category]="Hourly")

PerVSal = CALCULATE(MAX(Table[Salary]),Table[Category]="Per Visit")

AnnualSal = CALCULATE(MAX(Table[Salary]),Table[Category]="Annual")
ineedham's avatar
ineedham
Icon for Helper I rankHelper I
10 years ago

 

Adding those measures was a great idea, but my ultimate goal was to toggle between maps on one page, without having to create 3 separate tabs/maps.  I found a solution: the default Slicer Visual created the problems I mentioned above, but the Custom Chiclet Slicer I downloaded from the PowerBI Visuals pages works perfectly.

 

Thanks for your help, Eric.

  • Eric_Zhang's avatar
    Eric_Zhang
    Icon for Microsoft Employee rankMicrosoft Employee
    10 years ago

    ineedham

     

    Thanks for your sharing. :)

    Just one question to confirm, did you create a different diverging color scale for different categories in one filled map?

    • ineedham's avatar
      ineedham
      Icon for Helper I rankHelper I
      10 years ago

      No, I didn't.  The scales were automatically adjusted to the min and max of each category's values, and the color scale was the same for all 3.