How to show every month data for every year

[Anonymous]

 i created a clalender table used date hierarchy in axis in Line chart. In calender table having for 10 years.  i need to show every month enrollments for every year separately.

but for getting every months enrollments all years is getting in line chart. how to resolve this in Power BI.

[V-lianl-msft]

Hi @Anonymous ,

Try to create a year month column as the X axis:

Year_month = FORMAT('Table'[Date],"YYYY-MM")

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak · Accepted solution]

@Anonymous , Not very clear. Create a month year column in date table and use that.

Month Year = FORMAT([Date],"mmm-yyyy")
Month Year sort = FORMAT([Date],"yyyymm")