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 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
Then you can create new date table containing month number and month name column with matching value. In modelling tab create the relationship using the month number of new table with the existing table month .Now you can use month name in the chart.