Showing results for 
Search instead for 
Did you mean: 
Regular Visitor

Applying States to Different Regions -- Heatmap



I have a set of data in which the only locational data is a variable called 'Region'. There are several regions and each region represents several different US States. For example, the 'East' is a region that covers Kentucky, West Virginia, and Pennsylvania.


I also have other variables such as 'Sales', 'Cost', 'Profit', etc, all of which are calculated measures.


I would like to view the measures on the heatmap to see which regions are doing well and which may be underperforming. Is there a way to assign states to regions in some way?


Thank you in advance for the advice!

Community Support
Community Support

Hi @evpote01 ,


Not very clear about your requirement, can you share some sample data?

You may check the topic about How-to-Get-Your-Question-Answered-Quickly .


Best Regards,


Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.

Helpful resources

PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!