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
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.
.
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.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
112 | |
105 | |
95 | |
58 |
User | Count |
---|---|
174 | |
147 | |
136 | |
102 | |
82 |