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.
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
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.