Forum Discussion
x axis interval labeling
I have a data model whose lowest "date" resolution is fiscal month. That is, my "date" dimension table has 1 row per fiscal month. Because it's a dimension table, I have also included fiscal year a...
Make a column in your date table concatenating the Yr and Mo - something like CONCATENATE([YR],[MO]), Then make sure the fiscal yr/mo is sorted by a date:
ColumnTools>>>SortBy
when you bring the Yr/Mo into the xaxis, it will then be sorted in date order you need
I don't understand how that solves my problem. My problem isn't how to sort my text labels. As shown in the screenshot, my requirements are:
-the interval to be (fiscal) month (e.g., Aug FY20-21)
-the (fiscal) month field values not to be displayed
-the (fiscal) year label field to display at the beginning of each (fiscal) year (i.e., month 1 of each FY)