Forum Discussion
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):
| Region | Trend Numerator | Trend Denominator |
| East | 2 | 21 |
| East | 3 | 32 |
| Southeast | 7 | 46 |
| West | 2 | 11 |
| Northeast | 1 | 46 |
| North | 5 | 61 |
| West | 3 | 23 |
| ... | ... | ... |
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
- parry2k
Super User
Anonymous 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.⚡
parry2k How should I go about assigning multiple states to the same region?
- parry2k
Anonymous 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.
