cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
junder Frequent Visitor
Frequent Visitor

Column Order in PBI

How can I keep the column order from my data source? PBI seems to change to alpha order. Ex. - Columns labeled and ordered: 'Actual, Previous, Budget, Forecast', get reordered in PBI as 'Actual, Budget, Forecast, Previous'.

4 REPLIES 4
Super User
Super User

Re: Column Order in PBI

It's a feature...


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


Power BI Team AlexGorev
Power BI Team

Re: Column Order in PBI

If you are talking about the table\column order in the Field List, then curently you cannot change it. We do have a feature in the backlog to allow Alpha. Natural and Customer order.

 

If you want to sort categories in the visual using specific order, then you can use the Sort By feature in PBI Desktop. It allows you sorting one column in the model by another. You will need to create adiitional column in the table that contains the sort order as a numeric.

 

Alex.

ashishrj Senior Member
Senior Member

Re: Column Order in PBI

@junder You can create a new calculated column with Actual=1, Previous=2, Budget=3, Forecast=4 and later sort original calculated column based on this new calculated column by selecting the filed and Modeling option as shown below

sort.png

 

Highlighted
vvanasperen Frequent Visitor
Frequent Visitor

Re: Column Order in PBI

@AlexGorev: Could you point me to the link in the backlog? Or is this something we don't have to vote for anymore? ;-)

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

PBI Community Highlights

PBI Community Highlights

Check out what's new in the Power BI Community!

Top Ideas
Users Online
Currently online: 102 members 1,512 guests
Please welcome our newest community members: