Forum Discussion
Order in fields pane
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.
The OP asked about the order of field names in the Fields pane, not in a visualization.
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.
Thanks for the clarification Phil.
So if I understand it correctly, the solution is to:
1. create a new table with the 3 values as shown,
2. create a relationship for every query to that table,
3. set the desired order for every column
I appreciate the option, but for me this is too ham fisted and I would not likely bother. In one file alone I have 8 queries with well over 100 columns in total.
It would be a pain if you have lots and lots as you say.
I had models where I've perhaps wanted to override the default sorting on just a small number of columns at the most. Sorry about that.
Phil