Forum Discussion
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
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
HI mehaboob557 Unforunately, I don't have that option... any other ideas?
Make sure your Entry Date column is set to datatype Date/Time