Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Morgan2000
Frequent Visitor

Key for Maps

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

Morgan2000_0-1694517173576.png

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.

 

 

Morgan2000_1-1694517280590.png

 

 

1 REPLY 1
HarishKM
Memorable Member
Memorable Member

@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 

HarishKM_0-1694522176581.png


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

HarishKM_1-1694522415615.png

 

Thanks

Harish M

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.