Forum Discussion
JeroenN
10 years agoAdvocate I
Sorting date based axes
Power Bi sorts the X axes in a histogram automatically in alphabetic order. Is there a way to change this? I tried to add a numeric column to the axes, but this doesn't seem to work. Anybody have a ...
- 10 years ago
Sorry, I am still not 100% up with the correct terminology in Power BI.
On the home ribbon/menu of Power Bi Desktop, on the left hand side, click on the middle icon (Data view - not table view- sorry).
Select your table
select the Name column you want to resort in a different order
Click on the modelling ribbon/menu
Click "sort by column", and then select the id column
Go back to your report (top icon, report view on the left hand side).
MattAllington
10 years agoCommunity Champion
JeroenN wrote:The data in the tabel are already sorted the right way - that has no effect on the visual.
Are you saying you have followed my instructions and it didn't work?
JeroenN
10 years agoAdvocate I
Now it works!
I missed one part, because of the fact that my menu's are in Dutch.
Thanks Matt.