x axis interval labeling

[Anonymous]

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?

[samdthompson]

Sorry, I didnt understand the problem. No, i dont think that can be done using standard visuals. Its most probably a job for charticulator.

[samdthompson]

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

[Anonymous]

@samdthompson 

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)