Forum Discussion

baBI123's avatar
baBI123
Icon for Helper II rankHelper II
8 years ago
Solved

GROUP INTO MONTH

Hello POWER BI family,  I have a question:  How can I group this chart (see attachment) so that the values on the x-axis are grouped by month??  Thanks in advance
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    baBI123,

    If you create relationship between the SHOP WO TAT table and a calendar table  using date field, drag the date field of  the calendar table to X-axis of your chart, then you are able to get date hierachy and remove Year  & Quarter & Day as mehaboob557' s post.

    Another method is to create a MonthName field in your SHOP WO TAT table using DAX below, then drag the MonthName field to X-Axis of your chart.

    MonthName = SWITCH(MONTH('SHOP WO TAT'[Entry Date]),1,"January",2, "February",3,"March",4,"April", 5,"May",6,"June",7,"July",8,"August",9,"September",10,"October",11,"November",12,"December")



    Regards,
    Lydia

mehaboob557's avatar
mehaboob557
Icon for Resolver III rankResolver III
8 years ago

Hi,

 

You can do it my removing the year in the date heirarchi in the values section

 

     =====>    

 

This may help you to group in months

baBI123's avatar
baBI123
Icon for Helper II rankHelper II
8 years ago

HI mehaboob557 Unforunately, I don't have that option... any other ideas?

  • thomasronn's avatar
    thomasronn
    Icon for Resolver I rankResolver I
    8 years ago

    Make sure your Entry Date column is set to datatype Date/Time

  • mehaboob557's avatar
    mehaboob557
    Icon for Resolver III rankResolver III
    8 years ago

    Hi baBI123,

     

    Can you share me the sample pbix file .

     

    SO that i can check.

    • baBI123's avatar
      baBI123
      Icon for Helper II rankHelper II
      8 years ago

      Unfortunately, I can't share this file with you mehaboob557because it has private company information... Thank you for your help. It is still not working..:mansad:

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        baBI123，

        Have you checked my methods? The two methods work in my environment.

        Regards,
        Lydia