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
amitchandak's avatar
amitchandak
Super User
4 years ago

ScottMarwood , Have you use legends? because in that case it will not give fx option

ScottMarwood's avatar
ScottMarwood
Frequent Visitor
4 years ago

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
    Post 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
        Community 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!