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.
Anonymous , that is under column/measure tool and will appear when you click on column and measure
https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column
Thanks all for the answers. Maybe I did not describe my goal accurately.
I want to sort the data in the visualisation, lets say a table, by another (not visible) column than the one in the data.
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.
