Sort by a not visible column

[Anonymous]

I read some Answers to similar questions but theses dont seems to be accurate for my case.

The aim is pretty trivial: I want to sort my data by a column that you cant see or is not in the Visualisation.

I am coming from Tableau and this requirement seems pretty obvious to me. The aim is to keep my visualisation simple.

Puting another Column in ordner to sort by is not an option to me.

Thank you.

[amitchandak]

@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

[Anonymous]

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.

[v-deddai1-msft]

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

[Anonymous]

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.

[v-deddai1-msft]

Hi @Anonymous ,

Would you please show us more details about dynamic order so that we can help you well.

Best Regards,

Dedmon Dai

[Anonymous]

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

[v-deddai1-msft]

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

[Anonymous · Accepted solution]

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.

[FrankAT]

Hi @Anonymous 

create a column with the sort criteria. Select in data view the column that should be sorted by this criteria and use in Column Tools Sort by column.

 With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
FrankAT (Proud to be a Datanaut)

[Greg_Deckler]

@Anonymous - So, typically you would click on the column and then under Column tools in the ribbon click the Sort by column and choose the column by which you want sorting to occur. The column can be any column in the table, not just those in the visualization.