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
Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Microsoft Ignite 768x460.png

Find your focus

Explore the latest tools,training sessions,technical expertise, networking and more.

Power BI Womens Summit 2021 768 x460.jpg

Interviews, learning sessions, allies, and more!

#PowerBIWomenSummit

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!