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

Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now

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
Join our Fabric User Panel

Join our Fabric User Panel

Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.

February Power BI Update Carousel

Power BI Monthly Update - February 2026

Check out the February 2026 Power BI update to learn about new features.

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.