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.
Hi all!
I have my data broken down by states in one column but I want to be able to pull it in by regions with specific states.
How can I easily do that? Im new into power BI and really trying but feeling awful that I cant get it.
Solved! Go to Solution.
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
@bv27718n again what is the definition of the region? Do you need to be more specific? Maybe there is a wiki page or other web URL that has states by region which you can pull in Power bI but first, you need to define when you say region, what does it actually mean?
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.
I agree with @parry2k , you first need to define the concept of regions, nothing that indicates in your file.
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
i just cannot seem to get it right
Did you see my private message? I sent you back the file
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
wont let me PM. I was only working with the elite files, thats what i needed to see the visuals i have. v
that file should be correct, the chart on region is killing me, not sure how to make it show by region with the states that are actually in the region. last thing, can you explain how to do the correct formula for the percent change in the pf elite tab. it showss variance number only but i wanna try to get percent in it,
okay so i would do west, south, mid west and north east. within that would be the states, but how do i define that and add that in I guess
Private message please
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
5.21 and 5.20 are the biggest tables,
Yes, you have 2 options
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
@bv27718n well how you expect it to work if you don't have region information, you need to bring that in. How you define region?
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.
cool ,thanks but then you dont need the table no? or do i add that where
No don't add no table...just make sure you Goup them well
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
ok cool, then I should be able to go in add visuals only for selected regions correct?
Yes, The Regions(the group) you can use it in visuals as well as in slicers.
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
thanks for the help. Another question is, I created regions which is great, but when I go to create a group for say, west states only, it only shows the region not states. how do you rectify that?
Didn't understand, send me the file please
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
https://drive.google.com/file/d/1xWl-pLZ3m6xinlepSwWI1j7mRxaTJjxl/view?usp=sharing
So I get how to group regions in for the PF elite tab, and that works great. What I dont get though is in the tap for region, I want to show by region and the states within the region, but if i do a new group it will only show region names on the x axis not state names. i tried fixing but it wont group to show that. Additionally, I am lost how to do a correct formula for pf elite, the var change. i see the number change but i want to say this is my percent change year over year. it keeps giving errors.
Hi @bv27718n ,
You could add both region and state to x-axis and use drill down feature at the top right of the visual.
Best Regards,
Jay
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 |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |