Forum Discussion
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 me on how to sort this graph in chronological year? Any help is greatly appreciated!!
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.
-
2 Replies
Shravan133Super User
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 🙌
