Display Fiscal year/month on a visual

[Anonymous]

Hi Community,

I hope someone can help me out.  Our Fiscal year starts in July & ends in June.  I created fiscal year column using DAX in my Date table accordingly & sorted month by fiscal month number. In the image below, the report filter 'year' is the fiscal year and also on the graph its fiscal year. When I select year 2019 in report filter, I should see Jul 2019 to June 2020 on the graph, but it displays the 2019 year months only.  Any suggestions?

'

[amitchandak · Accepted solution]

@Anonymous , Please find the Jul_jun Calendar attached after the signature. It has sort logic for months.

You can also refer to my blog - 1.Creating Financial Calendar - From Any Month
https://community.powerbi.com/t5/Community-Blog/Creating-Financial-Calendar-Decoding-Date-and-Calendar-1-5-Power/ba-p/1187441

[Ashish_Mathur]

Hi,

Share the link from where i can download your PBI file.