Applying States to Different Regions -- Heatmap

[evpote01]

Hello!

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!

[v-jayw-msft]

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,

Jay