cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
FW94
Helper I
Helper I

Bar chart showing each day, want grouped by month

I have the below bar chart and I want it to display monthly totals, however it is currently showing the results for each individual day within the months. The date format is recorded as "7 May 2021" (for instance) in the data set, and is linked to a Calendar table. 

Power BI bar chart.PNG

Any help on how to essentially group these days just to show the monthly total would be super appreciated. Thanks.

1 ACCEPTED SOLUTION
amitchandak
Super User IV
Super User IV

@FW94 , if you have date/calendar table, then use month year column on axis

 

column

Month Year = FORMAT([Date],"mmm-yyyy")
Month Year sort = FORMAT([Date],"yyyymm") //sort month year on this



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

4 REPLIES 4
v-henryk-mstf
Community Support
Community Support

Hi @FW94 ,

 

You can change the continuous date column to a date with a hierarchical structure. Then drill down to month. I did a test, the reference is as follows:

v-henryk-mstf_0-1620721594814.pngv-henryk-mstf_1-1620721628589.png

the result like this:

v-henryk-mstf_2-1620721692584.png


If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi @v-henryk-mstf , thank you for looking into this for me. Since my post I have now managed to solve by following @amitchandak suggestiong of using a Month_Year column in the Calendar table.

amitchandak
Super User IV
Super User IV

@FW94 , if you have date/calendar table, then use month year column on axis

 

column

Month Year = FORMAT([Date],"mmm-yyyy")
Month Year sort = FORMAT([Date],"yyyymm") //sort month year on this



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

@amitchandak please excuse my ignorance, still getting to grips with the functionality of Power BI, but are you suggesting I add those DAX to the Data table fields, and then within the Axis of the chart?

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Top Solution Authors
Top Kudoed Authors