It would be very useful if we could set our fiscal year somewhere and have that utilised by charts. This could possibly be done either as a global setting or per chart. Currently to display fiscal year in a coherent way on visualisations we have to add a custom column to our date tables that will generate an appropriate label for charts e.g. (01) - Oct, (02) - Nov if your fiscal year starts in Oct. It would be much friendly if we could instruct visualisations where our fiscal year begins and have them intelligently label axis. I've noticed that if you are using a date field on the axis then visuals will change the labels based on various factors. For example for a certain period it may show individual dates, or months, or years depending on the size of the chart and other factors. This doesn't work with custom labels though and because you cannot add two labels to an axis e.g. months AND years I cannot have a chart easily stretch and represent a period longer than a year when using fiscal year labels. Hope this makes sense 🙂
... View more