cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Berbatov
Regular Visitor

Group column chart axis date by month

Hi all,

 

I'm looking to create a new bar chart. The data I'm plotting tracks certain counts by date. Wihtin the chart, however, I want it grouped by month.

 

I already looked at posts like...

...but for some reason, the menu items are not enabled / visible for me.

 

Berbatov_0-1669402479610.png

Berbatov_1-1669402599533.png

 

 

 

Any help to get the columns grouped would be much appreciated, thanks!

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

Does your data source have a calendar table? If not then you need to convert from Live to Direct Query and add the Month column manually.

View solution in original post

1 REPLY 1
lbendlin
Super User
Super User

Does your data source have a calendar table? If not then you need to convert from Live to Direct Query and add the Month column manually.

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.