Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I am trying to sort month based on Fiscal year from July to June. I got some solution from here:
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:
Solved! Go to 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.
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.
@shbz1690 , I have give all two create calendar for any month here
Check the pbix here
https://www.dropbox.com/s/us4vk2kizs32nzo/Jul_2_Jun_Qtr_Cal.pbix?dl=0
@shbz1690 - Can you just use MonthName = FORMAT([Date],"mmmm")?
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 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |