Forum Discussion
Order in fields pane
How can I see the fields located in fields pane, in order spacified in the data source, rather than alphabetical order.
JCA
11 Replies
Surprisingly I could not find this raised as an idea so I have done that here:
Nothing surprises me any more, eg. the fact that 4 years later it hasn't been addressed!
In Power BI Desktop, data fields are always in alphabetical order in Dataset. It's default behavior by design. Currently, it's not supported to control/set the order. For your requirement, you may sumbit a feature request on Ideas: https://support.powerbi.com/forums/265200-power-bi
Regards,
You can do this by taking advantage of the [Sort by other column] feature.
Check out the solution to this question :
https://community.powerbi.com/t5/Desktop/Stacked-graph-sort-order/m-p/62297/highlight/true#M25651
Follow it and it will control the order of the fields as well.
Yes, the [Sort by Column] option also controls that.
It can
- control the order items are displayed on an axis
- the order items are displayed in a legend
- the order of wedges/blocks in clustered column and pie visuals (etc)
- and, it also controls the order that fieldnames are displayed in the Fields pane
See the images below to see what I mean.
