Forum Discussion
P0W3RB1
Helper I
Helper IFiscal 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...
Check following.
1. Do you have a calendar or date table.
2. Create columns for MonthName = FORMAT([FullDate], "MMM"), Fiscal Year, FiscalMonthNumber
3. FiscalYear can be based on formula like If (Month([FullDate]) >= 7, Year([FullDate]), Year([FullDate]) - 1)
4. Similarly FiscalMonthNumber can be based on a formula If (Month([FullDate]) >= 7, Month([FullDate]) -6 , Month([FullDate]) +6 ). This will generate the month numbers as 1 for July and 12 for June.
5. For the MonthName set the sort by column ass FiscalMonthNumber.
6. When you place MonthName in the bar chart it will always show Starting with July.
If it works please accept this as a solution and also give kudos.
Cheers
CheenuSing