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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
AparnaJ
Helper I
Helper I

Gantt Chart with Fiscal year

Hi All,

We are building a solution showing our roadmap. We have start and end dates for our projects and show them visually using a gantt chart. However we go by Fiscal Year (July to June). But when we provide start/end dates to the charts its taking as calendar year, is there a way to tweak this? Also please advice if there are any other charts that take the dates as fiscal year. Thank you.

1 ACCEPTED SOLUTION
AparnaJ
Helper I
Helper I

Thank you. Also found a new visual Gantt Chart-xViz where we can select Fiscal year in format and give starting month. 

View solution in original post

2 REPLIES 2
AparnaJ
Helper I
Helper I

Thank you. Also found a new visual Gantt Chart-xViz where we can select Fiscal year in format and give starting month. 

v-stephen-msft
Community Support
Community Support

Hi @AparnaJ ,

 

From what I'm understanding, you want to sort data by fiscal year in the x-axis, right?

If so, there's a solution in this similar post.

Solved: change graph X-axis order to fiscal year - Microsoft Power BI Community

Go to the query editor, and created a Month column and created a conditional column based on the Month. Here is the M code.

 

= Table.AddColumn(#"Renamed Columns1", "Custom", each if [#"Month-Number"] = 1 then 8 
else if [#"Month-Number"] = 2 then 9 
else if [#"Month-Number"] = 3 then 10 
else if [#"Month-Number"] = 4 then 11 
else if [#"Month-Number"] = 5 then 12
else if [#"Month-Number"] = 6 then 1
else if [#"Month-Number"] = 7 then 2 
else if [#"Month-Number"] = 8 then 3 
else if [#"Month-Number"] = 9 then 4 
else if [#"Month-Number"] = 10 then 5 
else if [#"Month-Number"] = 11 then 6 
else if [#"Month-Number"] = 12 then 7 
else null)

 

and change the Custom Column format to Number.

Go back to Power BI Desktop, select the Date and then goto Modeling Tab and then select sort by Custom column.

 

Or please try anther solution in the following blog.

Sorting Data by Fiscal Year in Power BI - PowerObjects | Dynamics 365 | HCLTech

 

 

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!