Forum Discussion
Solved
Sort Bar Graph in Power BI by Year
Hi there! I am struggling to sort my bar graph by year in my Power BI dashboard. I searched and searched and every solution I find does not apply / the option does not exist. Could anyone direct ...
Make sure your year column is numeric or date datatype.
If you’re using a "Year" label that is textual but want it to follow a specific order:
-
Create a new column like
YearNumber = VALUE([Year])(if it’s not already numeric). -
Go to the “Year” column in Data view.
-
Select Sort by Column → choose your
YearNumbercolumn.
-
The column type was Text. Changing to Number fixed it!! Thank you so much 🙌