Display graph order for the Financial year which is different to calendar year

[TonyR]

Hi, Our financial year is Sep to August.

How can I get the visualizations to display our fy correctly ?

Thx

Tony

[Anonymous]

Hi @TonyR

I had earlier posted a solution on this.

http://community.powerbi.com/t5/Desktop/Creating-a-Fiscal-Year-amp-Fiscal-Quarter-in-a-DATE-calendar...

If this works please accept this as a solution and also give KUDOS.

Cheers

CheenuSing

[Britknee30]

I dont know HOW this worked, but it did.  THANK YOU

[tringuyenminh92]

Hi @TonyR,

To understand your situation, could you please provide some picture about your data structure/data table and your expectation?

So far you could

• add Calculated Column in your Dates table or fact table to grouping your custom months by if(MonthColumn="September" || MonthColumn="August" , "f1", "f2orAnotherNestedIf"  ) condition
• Or use adding condition column in query editor
• another options...

[TonyR]

Hi Tring

Info is displaying sales data by month. I did a calaculated column similar to what you suggested . Sep is Month 1, October is month 2, Jan is month 5 etc. I can then display the monthly sales data correctly however then the labels displayed are the numeric value for the month where I want the actual month name displayed. see here as an example  http://screencast.com/t/8YbgHbac

[tringuyenminh92]

Hi @TonyR,

You could use format(monthvalue,"MMM") to have month name. Please try it and let me know cause sometime it will not work

[Vvelarde · Accepted solution]

@TonyR

Hi, select your Month (in names) and go to Modeling Sort By Column --> Select your Month in numbers.

Next, in your visual put the Month (in Names version).

Ready.

[Anonymous]

What we do if i need to sorting FY YEAR format 2020-2021 in Line Graph ...
Month we can do but what about FY year 

[RodrigoTXRA]

Thanks @Vvelarde, such a simple and quick solution. Well done and thanks for sharing it