Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Sort by a not visible column

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.

  • Anonymous's avatar
    Anonymous
    6 years ago

    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.

     

10 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      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's avatar
        v-deddai1-msft
        Icon for Community Support rankCommunity Support
        6 years ago

        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

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    6 years ago

    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.

     

     

  • FrankAT's avatar
    FrankAT
    Icon for Community Champion rankCommunity Champion
    6 years ago

    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)