Can't display my filled map with gradient?

[sfmike99]

I am trying to use filled maps to visualize different variables using slicers.

Table 1 contains the specific locations I am interested in:

Table 2 contains the data for five variables in this format:

Table 1 and 2 are joined on the "geoID" column (FIPS with a prefix). But I know I can't use that directly in Filled Maps, so I use the custom column "MapLoc" column from Table 1.

All works as expected except for one thing: even though the slicers have chosen only one variable at a time, the map wants to treat each one as distinct, and I can't make a gradient map of their relative values. Do I need the data in five different tables?

Thanks for any suggestions. 

[Anonymous]

Hi, @sfmike99 

As you can see, there is no fx function in the color community area, so it cannot implement the gradient function. If you need this function, you can propose it in the Ideas forum and vote for it. When enough people vote for it, your idea will be updated in the future version.

Home (microsoft.com)
You can link your ideas in this reply and mark it as a solution so that other community members can vote for it when searching for similar problems.

As an alternative solution, you can look for maps in the visual marketplace that have been developed by others, and look for maps that provide that functionality to meet your actual needs.

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[sfmike99]

On this Microsoft page it describes how to "Format a filled map", including using gradients. What am I missing?

[Anonymous]

Hi, @sfmike99 

Thank you for your reply. If you need the gradient fx shown in the document, you can follow the steps below to achieve it:

As you demonstrated, this functionality is unavailable when there are fields in the legend.

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.