Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
@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.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
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.
@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.⚡
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |