Forum Discussion

sfmike99's avatar
sfmike99
Icon for Advocate II rankAdvocate II
1 year ago

Can't display my filled map with gradient?

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. 

 

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    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's avatar
      sfmike99
      Icon for Advocate II rankAdvocate II

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

       

       

      • Anonymous's avatar
        Anonymous
        Not applicable

        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.