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

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