Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 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.
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 Order
Error
Solved! Go to Solution.
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!
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.
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.
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!
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.
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.
User | Count |
---|---|
121 | |
72 | |
71 | |
57 | |
50 |
User | Count |
---|---|
167 | |
83 | |
68 | |
65 | |
55 |