Gantt Chart with Fiscal year

[AparnaJ]

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.

[AparnaJ · Accepted solution]

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]

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.