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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

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
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.