Filled Map - Display revenue range by state/location

[geotech]

Hello All,

I have searched this subject without success and it's possible that I am going out of order to achieve the desired results. I have the table below that I would like to display on a Filled Map according to the revenue by State and where it falls into a range (e.g. $0-1000, $1000-5000, $5000-10000, >$10000). I can create a new table within Power BI that sums the revene by State, however I am not sure if I can use this table as a reference for a Filled Map. Is it possible to do this directly through the Filled Map tool or will I need to process the data first and then use the Filled Map tool?

Customer Name	Project Name	State	Revenue
Customer 1	Project 1	NY	1000
Customer 1	Project 2	NY	6000
Customer 1	Project 3	NY	13000
Customer 2	Project 4	GA	23000
Customer 3	Project 5	CA	40000
Customer 3	Project 6	CA	2000

Thank you in advance

[parry2k · Accepted solution]

@geotech you can create a measure and use that in condition formatting for filled map.

See attached, I have two measures, one for Sum of Revenue and other for color. I just created a range to show the different color, you can adjust the measure as per your need.

[Anonymous]

Just wanted to comment that I've been looking for a solution for days and this helped me perfectly! Thank you!

[geotech]

@parry2k , thank you for your quick response and elegant solution! I will read more into measures to see how else they can be used. This solves my current problem - thank you, again.