Line Chart Expense by Month with Lines for Each Year Top of Each Other

[asjones]

I have expenes by month for many yhears back. I am trying to build a line chart showing expense by month with a seperate line for each fiscal year. The lines for each year would be on top of each other so one can compare differences, trends of up and down etc. I ran into some issues so i looked online and watched a few videos and sitll amd not gettinga corrrect chart type. The closes chart I am getting is the expense by year as seen below after i drill down one level.

The first screenshot belows shows after "drill down" but the years still are on the X axis not the months.
The second screenshot is before I "drill down"
I incluced in the screenshot the Axis information, any idea what i am doing wrong?

thanks

Alan

[asjones]

@vicky_  & @v-xiaocliu-msft 

Thanks for your help adding the month specfic column fixed the issue. I also added a month number and I sorted in the table and tried soring with the Sorby By Column option and neither worked for sorting. It still sorted by month name. Not sure what i am missing. I did some searches and they all suggested what I tried.

thanks

Alan

[asjones]

@vicky_,I think that may be the issue... I realized in some other cases a date field makes its own hierarchy but this done does not.

@v-xiaocliu-msftthanks for the sample. In some cases, the date fields makes its own hierarchy and this case it is not.
thanks to both of you for your ideas. I will test later today.

Alan

[v-xiaocliu-msft]

Hi @asjones ,

I made a sampl for you.

Best  Regards,

Wearsky

[Ashish_Mathur]

Hi,

Share the download link of the PBI file.

[vicky_]

Does "Date To" already contain the month that you're trying to compare (in the format dd/mm or just mmm without the year part?)
If so, then you can either remove the year from your date heirarchy or change the way that you drill down. I.e use the green drill down button and keep the year ONLY in the legend (and upper level of the heirarchy)

Otherwise, you'll need to create a column on your date table / column that has JUST the month so that the lines will overlap. Something like:

Month = FORMAT(Table[Date To], "mmm")

and to get it to sort correctly, create another column that has the month as a number:

Month Number = INT(FORMAT(Table[Date To], "mm"))

and then sort the former by the latter.