Forum Discussion
P0W3RB1
Helper I
10 years agoFiscal Years in a Bar Chart
I Have a bar chart, and a timline from the custom visuals where you can set a fiscal year which is great, but lets say a fiscal year is july to july, i can select that fiscal year on the timeline but...
kcantor
Community Champion
10 years agoTry this:
http://powerpivotfaq.com/Lists/TGPPF/DispForm.aspx?ID=125
Here is the longer version:
http://www.powerpivotblog.nl/using-time-intelligent-powerpivot-functions-with-fiscal-year/
This should solve your problem.