Forum Discussion
Grouping Text by Month
Hello, I am trying to group closed accounts by month. The data i have is account type, weather the account is closed or not. So i have filtered this to be closed. Then the other data i have is d...
Hi, try inserting the month column created in x axis of the chart. If you can able to post ss it will be useful
So have managed to do what you suggested, however the next issue is now months 11 and 12 showing before month 1. I would also rather in be in the format MMM so Jan, Feb, Mar, ect.
Hi,
Try creating new column
Month name=format(date(1,[month],1),"MMM")
The above format will contain the name of the month .try inserting that in the x axis. If order is not correct , try to sort the month name column with month.
Ps-if answer is working please accept this as the solution.
Using DirectQuery & PowerQuery so the function FORMAT wont be recognised
