how to get month name instead of number

[shbz1690]

I am trying to sort month based on Fiscal year from July to June. I got some solution from here:

https://community.powerbi.com/t5/Desktop/Creating-a-Fiscal-Year-amp-Fiscal-Quarter-in-a-DATE-calenda...

the point where I got stauck is that my month report is showing like this, :

month starts at July and ending at June correctlry. But I want month name not numbers. And those missing values for month 1,3,5,7,9,11 , I am not sure what is that.

I have used this formula to create month column:  

FiscalMonth = If( Month([Date]) >= 7 , Month([Date]) - 6, Month([Date]) + 6)

[v-jingzhang · Accepted solution]

Hi @shbz1690 , add a column in your date table to use Month name, and most importantly sort this month name column by Fiscal month number column. After both steps, you will be able to use the month name column in your chart’s X-axis field and see it sort well.

Fiscal Month = FORMAT('Calendar'[Date],"mmmm")

FiscalMonthNo = If( Month([Date]) >= 7 , Month([Date]) - 6, Month([Date]) + 6)

Best Regards,

Community Support Team _ Jing Zhang

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

[amitchandak]

@shbz1690 , I have give all two create calendar for any month here

https://community.powerbi.com/t5/Community-Blog/Creating-Financial-Calendar-Decoding-Date-and-Calend...

Check the pbix here

https://www.dropbox.com/s/us4vk2kizs32nzo/Jul_2_Jun_Qtr_Cal.pbix?dl=0

[Greg_Deckler]

@shbz1690 - Can you just use MonthName = FORMAT([Date],"mmmm")?

[Fowmy]

@shbz1690 

you need to add a column in your date table to format as Month Name:

= FORMAT([DATE], "Mmmm")

Check out his video from Alberto : https://www.youtube.com/watch?v=0peKz7XjEdw

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn