Forum Discussion

TinyTV's avatar
TinyTV
New Member
8 years ago
Solved

Sort chart based on hidden column

Hi,   I'm new to Power BI and have used some visualisation tools in the past but am struggling with this one.   I need to order a chart by a column which I do not want to display i.e. by a hidden...
  • v-huizhn-msft's avatar
    v-huizhn-msft
    8 years ago

    Hi TinyTV,

    We can not sort by a measure, but we can sort by a calculated column through test. You need to select the column by which we want to sort, in the Fields pane, the Sort by Column button becomes active. You cam review more details in the blog.



    Best Regards,
    Angelia

Greg_Deckler's avatar
Greg_Deckler
Community Champion
8 years ago

Generally this is done by using the Sort By functionality in the model. So you can select the column that you are displaying in the model and choose Sort By and then have it sorted by a different column.

  • TinyTV's avatar
    TinyTV
    New Member
    8 years ago

    Hi,

     

    Thanks for response - I've had some success with this on a few columns and charts but then not on others. Is there a limit to having this functionality work on a created column or measure instead of one that was included as part of the data that was imported?

     

    Thanks

    • v-huizhn-msft's avatar
      v-huizhn-msft
      Microsoft Employee
      8 years ago

      Hi TinyTV,

      We can not sort by a measure, but we can sort by a calculated column through test. You need to select the column by which we want to sort, in the Fields pane, the Sort by Column button becomes active. You cam review more details in the blog.



      Best Regards,
      Angelia