Forum Discussion
Sort by a not visible column
Meanwhile I found a kind of a solution and I had to accept that this basic requirement is not as basic as it seems to be. Here is the Link to the video.
You basically have to eather use the hidden-value as a Tooltip, than its kind of hidden but still present to sort. Or you have to hide the column by desactivating "Word Wrap" and adjusting it manually.
Hi Anonymous ,
You can sort by column that didn't appear in your viusalization. What did you mean another (not visible) column? Or you can create a sort table and sort the fact table by the related data in sort table and hide it in the report view.
Please refer to the https://radacad.com/sort-a-column-with-a-custom-order-in-power-bi for detailed steps.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
Thank you.
Coming from Tableau this requirement feels so basic to me and I am really surprised that this is not a standard function in PowerBI.
The solution you posted is good a for static order. In my case I need a dynamic order.
Hi Anonymous ,
Would you please show us more details about dynamic order so that we can help you well.
Best Regards,
Dedmon Dai
Lets say I have URL from different Websites. Each URL have two values A & B.
My Goal is a Matrix Visualization of all URL with the value of A but sorted on the value B. Which is pretty standard but I dont want to see the column of the B value (in order to not overload the Matrix).
Hi Anonymous ,
I never got to the root of your problem.You can try sort Column A by Column B, and you don't need to put the Column B into visual. Maybe some screenshot will help us get more details about your reuqirements.
Best Regards,
Dedmon Dai