Forum Discussion
Dynamic re-ordering by user
Thank you!
I have tried sorting by another column, and it's not what I need, unfortunately.
The number of items is many hundreds; a particular user is likely to filter them down to 5-10. There's no pre-determined way of ordering them. To put it differently, a user goes through a fairly complex process when deciding how to order the items, and ultimately the ordering must remain a user's decision.
That Inforiver video looks exactly like what I am trying to achieve ;o)
Alternatively, if you have seen ordering columns in a Sharepoint view setup, something similar could work.
I guess the other option is good old Excel...
Hi, PowerBI__newbie
Thank you very much for your reply. In the default table visual, you can only customize the sorting by other columns or measures. You can follow these steps to take the visual you need:
Hope the above can be helpful to you.
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you! I am trying to stick to standard PowerBI, though.
One option I am exploring is:
- creating multiple tables for Name, eg Rank_1_Name, Rank_2_Name, etc.
- creating a separate Age measure for each Rank_X_Name
- adding a slicer for each Rank_1_Name, Rank_2_Name, etc
- using a multi-row card to bring in Age
However, in reality I have around 15 columns in the original table that I need to show (as rows). With 10 slicers, that means creating 150 measures... a nightmare to maintain! :o(
is there perhaps a more efficient way of achieving this?
In matrix terms, I simply need to join transposed copies of the original data filtered on Name being equal to first-ranked, second-ranked, etc values. Don't know how to achieve this in PowerBI, though!