Forum Discussion

tristanweeks47's avatar
tristanweeks47
Frequent Visitor
3 years ago

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...
Need Help
Tips and Tricks
Tutorial Requests
tristanweeks47's avatar
tristanweeks47
Frequent Visitor
3 years ago

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. 

AjithPrasath's avatar
AjithPrasath
Resolver II
3 years ago

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.

  • tristanweeks47's avatar
    tristanweeks47
    Frequent Visitor
    3 years ago

    Using DirectQuery & PowerQuery so the function FORMAT wont be recognised

    • AjithPrasath's avatar
      AjithPrasath
      Resolver II
      3 years ago

      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.