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 cr...
Need Help
Tutorial Requests
netanel's avatar
netanel
Icon for Post Prodigy rankPost Prodigy
4 years ago

you can Share a PBIX file or some PIC?

 

try use filed formattig

if not you can creat a side Table 

ScottMarwood's avatar
ScottMarwood
Frequent Visitor
4 years ago

I seem to have solved the problem, I needed to create a custom shape map with our area codes to get it to work.

 

My issue now is that I would like to average sales over a 3 month period and have them show one colour for over $5,000 and one for under £5,000, is this possible? I understand I may need to create a new measure.

  • v-kelly-msft's avatar
    v-kelly-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi  ScottMarwood ,

     

    Could you pls provide some pics to describe your requirement in detail?

     

    Best Regards,
    Kelly

    Did I answer your question? Mark my reply as a solution!