Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The 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.

Reply
utkarshsingh3
New Member

Sorting Data when you've duplicate regions in another column

Hello! I have 3 columns in a table. First column is Order, Second is Regions and Third is Regions groups (I have grouped US East, West, Central and National as US All Entities). Now, when I try to sort the data by First Column "Order". It's not letting me to sort the data. I want to sort the data by Order.

.Table - I want to sort the data by OrderTable - I want to sort the data by OrderErrorError

2 ACCEPTED SOLUTIONS
mh2587
Super User
Super User

You can't sort that as there multiple orders values for US All Entities for that create another column for each reporting region group assign unique number in that column


Did I answer your question? If so, please mark my post as a solution!


Proud to be a Super User!




LinkedIn Icon
Muhammad Hasnain



View solution in original post

Hi, 

Thanks for the solution @mh2587  provided, and i want to offer some more informaiton for user to refer to.

hello @utkarshsingh3 , based on your description, you can create a new table.

Table 2 = SUMMARIZE('Table',[Reporting Region(groups)],"Order",MIN('Table'[Order]))

Then click the group column and select sort by order in the new table, and create a relationship between tables.

vxinruzhumsft_0-1713235885563.png

 

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

View solution in original post

3 REPLIES 3
mh2587
Super User
Super User

You can't sort that as there multiple orders values for US All Entities for that create another column for each reporting region group assign unique number in that column


Did I answer your question? If so, please mark my post as a solution!


Proud to be a Super User!




LinkedIn Icon
Muhammad Hasnain



its not happening...I tried giving order for reporting groups. Can you please advise?

Hi, 

Thanks for the solution @mh2587  provided, and i want to offer some more informaiton for user to refer to.

hello @utkarshsingh3 , based on your description, you can create a new table.

Table 2 = SUMMARIZE('Table',[Reporting Region(groups)],"Order",MIN('Table'[Order]))

Then click the group column and select sort by order in the new table, and create a relationship between tables.

vxinruzhumsft_0-1713235885563.png

 

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!