Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
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.
Solved! Go to Solution.
Thank you. Also found a new visual Gantt Chart-xViz where we can select Fiscal year in format and give starting month.
Thank you. Also found a new visual Gantt Chart-xViz where we can select Fiscal year in format and give starting month.
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.
User | Count |
---|---|
121 | |
72 | |
71 | |
57 | |
50 |
User | Count |
---|---|
167 | |
83 | |
68 | |
65 | |
55 |