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 attributes in it. So, an example row is like:
Fiscal Month Key Fiscal Month Name Fiscal Year ID Fiscal Year Name
202101 Apr FY21-22 2021 FY21-22
I need to create a line chart with fiscal month as my x-axis, but modified to look like:
That is:
1) The x axis resolution has to be fiscal month.
2) But, the field labels for fiscal month should not be displayed.
3) Instead, for month 1 of each FY, display a fiscal year label.
How can I achieve this? Is this even possible in PBI?
3 Replies
Sorry, I didnt understand the problem. No, i dont think that can be done using standard visuals. Its most probably a job for charticulator.
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)
