Forum Discussion

Jmccoy's avatar
Jmccoy
Helper II
5 years ago
Solved

Shape Map Legend Colors

So maybe I am working with this visual wrong. I have a shape map that I am trying to get to change colors based on a region. In the location pane I put in my state column, this represents every state...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hello Jmccoy 
    I've made a sample data according to the image and plot it into a shape map.
    To get the color you have to plot values into color saturation.

VikasKarnekanti's avatar
VikasKarnekanti
Regular Visitor
2 years ago

Hello Team,

I am currently working with Power BI Shape Maps, where I have implemented a time slicer. I am using three columns for maps: Location, Dates Column, and Legend.

I have created a measure to calculate Achievements based on the Dates.

Now, I want to create another measure using the above measure to generate ranges for achievements using the Percentile function. However, the Percentile function does not seem to accept measures directly.

I attempted to address this by creating a summarized table and generating a column for the achievements. But, when the time slicer changes (i.e., transitioning from the start date to the end date), the data changes accordingly. Unfortunately, the ranges do not dynamically adjust for the modified data.

I am seeking guidance on creating a measure for ranges using the achievement measure. For example, the desired output ranges are: 1-30, 31-45, 46-75, 76-99.

 

 

Thank you,
Vikas.K