Forum Discussion

Morgan2000's avatar
Morgan2000
Frequent Visitor
2 years ago

Key for Maps

I am trying to create a key for some conditional formatting I have on a map.  The conditional formatting is below.

Is it possible to get the 'highest', 'middle' and 'lowest' values to display in a text box?

 

This is to create a key to the map that shows what the colours mean such as the below.

 

 

 

 

Need Help

1 Reply

  • HarishKM's avatar
    HarishKM
    Super User
    2 years ago

    Morgan2000 Hello,
    You can refer below dax for your requirement.

    Color option = IF(SUM(financials[Gross Sales]) >450000000,"high",IF(SUM(financials[Gross Sales])>35000000 ,"Mid" ,IF(SUM(financials[Gross Sales])<35000000,"Low")))

    You can create similar dax.

    or 
    You can use conditional column in power query then define your requirement for conditonal formating 


    then you can use this color option and use color like below.

     

    Thanks

    Harish M