cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
evpote01
Regular Visitor

United States Heat Map Question

I have a data table that has the following variables (along with others that are not relevant to the issue I'm having):

 

RegionTrend NumeratorTrend Denominator
East221
East332
Southeast746
West211
Northeast146
North561
West323
.........

 

I have created a measure called "Trend" that = Trend Numerator / Trend Denominator. Each region has several states associated with it, for example the West region is representative of California, Arizona, Nevada, Washington, and Oregon. State is not a variable in my dataset, the only kind of variable related to location is region. I would like to create a heat map of the United States where I can use the Trend as a value so that the region is red if the trend is bad (high, positive trend) and green if the trend is good (low, negative trend). I am wondering if there is a way to apply the different states to the regions or vice versa so that I can then use that on a heatmap of the US in some way.

 

Thank you in advance!

3 REPLIES 3
parry2k
Super User
Super User

@evpote01 you will add another column called State and there will be a row for each state that makes up that region with the same data.






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





parry2k
Super User
Super User

@evpote01 I think what you need is to bring States for each Region and these states will have the same value for Trend and use State to plot the heat map, since each State in a region will have the same value, it will look like one region.

 

Follow us on LinkedIn

 

Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would  Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

 

Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.

 






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





@parry2k  How should I go about assigning multiple states to the same region?

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.