Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
All
I need some help in how to do this. I have five territories in my company and they show up as Territory in my model. Each account is assigned to a territory, so in my model under data, this is under Accounts.
The territories are Metro, Mid, NE, PA, and UNY.
What I want to accomplish is to still show each territory indiviudally, but I also need to report the data additionally as Data South and Data North
Data South would be Metro, UNY, PA and Mid
Data North would be just NE
If I drag Territory to a table...I can select each territory individually. Is there a way to do accomplish the creation of this so that if I drag it to a table for example I would show Data North and Data South and could select one, the other or both?
Emma
Solved! Go to Solution.
Hi @emma313823, you can use Grouping feature.
Select the column items of which you want to group, click "New group" feature:
Now gorup items as you need:
Here is the final result:
You can learn more about this feature here - Use grouping and binning in Power BI Desktop - Power BI | Microsoft Learn
Good luck 🙂
Hi @emma313823, you can use Grouping feature.
Select the column items of which you want to group, click "New group" feature:
Now gorup items as you need:
Here is the final result:
You can learn more about this feature here - Use grouping and binning in Power BI Desktop - Power BI | Microsoft Learn
Good luck 🙂
Hi @emma313823
You can right click on the Territory and select New group.
Then do a grouping like this:
Then you can use your created group in any visual, or as a filter:
Hope this helps! Let me know if you have any questions.
Proud to be a Super User! | |
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the February 2025 Power BI update to learn about new features.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
84 | |
69 | |
68 | |
39 | |
37 |