Forum Discussion

ScottMarwood's avatar
ScottMarwood
Frequent Visitor
4 years ago

Filled maps based on average sales

Hi All,

 

I am looking to create a map which will be coloured per sales area by average sales over a 12 month period, ie green if over 5,000 and red if below, is this possible?

 

When i try to create the map is simply gives each sales are its own colour and I have no option to create fx. I have tries filled map and shape map.

 

Thanks in advance!

5 Replies

    • ScottMarwood's avatar
      ScottMarwood
      Frequent Visitor

      I have, that may be the answer, but where do i put the Area codes? if I put them in Location I get a blank map

      • netanel's avatar
        netanel
        Icon for Post Prodigy rankPost Prodigy

        you can Share a PBIX file or some PIC?

         

        try use filed formattig

        if not you can creat a side Table