Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
I have no idea why my fiscal yweek slicer isn't going from 1-53 in order. Can someone please help?
The fiscal month starts october...
THanks!
Solved! Go to Solution.
Hi , @lennyt99
This happens because your field is in a text format.Power BI sorts you in text format.
If you want to sort by Date , you can select the filed , and click "Sort By Column" in "Column Tools" , like this:
My test data :
The result is as follows:
For more infomation, you can refer to this document:
Sort one column by another column in Power BI - Power BI | Microsoft Learn
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
@aniya, it works!!!
Thank you!
Hi , @lennyt99
This happens because your field is in a text format.Power BI sorts you in text format.
If you want to sort by Date , you can select the filed , and click "Sort By Column" in "Column Tools" , like this:
My test data :
The result is as follows:
For more infomation, you can refer to this document:
Sort one column by another column in Power BI - Power BI | Microsoft Learn
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 19 | |
| 10 | |
| 9 | |
| 7 | |
| 7 |