Remove Year from line chart and only include the Month

[dwel0120]

I want to remove the year from my line chart and only include the month. I have a custom sort on the month because I want it to show July 1 through June 30. If I try the date hierarchy to only show month, I can't get it to do a custom sort. I have also tried creating a new column with the format mmm and placing that into the line chart and it still doesn't work. It still shows the year. Help please!

[v-luwang-msft]

Hi @dwel0120 ,

You could try the below  solutions:

Solution1:

Based on table ,create a new column:

month = FORMAT('table'[Date],"MMMM")

yearmon = FORMAT('table'[Date],"YYYYMM")

Then click month then sort by the new column:

Final create visual ,you will get you want:

Solution 2:

month = FORMAT('table'[Date],"MMMM")

Create a sort table :

then sort by index:

Create relationship:

Based on two table ,create visual :

refer:https://community.powerbi.com/t5/Desktop/Data-sorted-by-Month-Number-but-Month-Name-is-still-showing... 

Wish it is helpful for you!

Best Regards

Lucien

[amitchandak · Accepted solution]

@dwel0120 , You can have column like 

Month = FORMAT([Date],"mmm")
Month sort = if(month([Date])>6, month([Date]) -6 , month([Date]) +6)

Sort month on Month Sort column.

But that will not work across year.

For that have two column on axis Year and month , Sort  on them uncheck concatenate label, if need sort again