Forum Discussion
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 ...
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
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