The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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!!
Solved! Go to Solution.
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 YearNumber
column.
The column type was Text. Changing to Number fixed it!! Thank you so much 🙌
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 YearNumber
column.
User | Count |
---|---|
75 | |
70 | |
39 | |
30 | |
28 |
User | Count |
---|---|
104 | |
95 | |
51 | |
48 | |
46 |