Forum Discussion
Solved
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 ...
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).
If you have a sort order in mind, load that up with your dimension data. Then in the table view, select "sort by column" to sort the Alpha column by the numeric column