Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

Sorting Clustered Column Chart

Hello,

 

I have a clustered column chart with Months in the x-axis. It's currently sorted from Jan 01 2020 through Dec 31 2020. 

 

Is there a way to sort the chart from Feb 01 2020 - Jan 31 2021 please to fit a fiscal year calendar?

 

Thank you,

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Thank you for triggering thoughts in my brain. I found the how-to here: 

 

https://www.powerobjects.com/blog/2018/12/19/sorting-data-fiscal-year-power-bi/

 

Thank you!!!

View solution in original post

2 REPLIES 2
az38
Community Champion
Community Champion

Hi @Anonymous 

if you have fiscal calendar column you can use Sort by Column button https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column


do not hesitate to give a kudo to useful posts and mark solutions as solution
LinkedIn
Anonymous
Not applicable

Thank you for triggering thoughts in my brain. I found the how-to here: 

 

https://www.powerobjects.com/blog/2018/12/19/sorting-data-fiscal-year-power-bi/

 

Thank you!!!

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.