Forum Discussion
justlogmein
Helper III
Helper IIIPower Query column sort not propogating to the tables
I am trying to sort my data and I have heard all the transforming is supposed to be done in Power Query. But it's like Power Query and the normal tables within Power BI (whatever you call it, in Exce...
speedramps
Super User
Super UserPower BI visuals display columns in alpha/numeric sequence NOT by how data is sorted in Power Query.
For example month names will ABC sort as April, Feb, Jan,, June, March, May.
However you can add an extra month number in Power Query (1 to 12).
Then click on the Modelling tab, click on Month Name and Sort by Month Number.
The Month Name will then sort by Jan, Feb, Mar, April etc on visuals.
Please click thumbs up and accept as solution buttons. Thanks.