Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Any help on how to essentially group these days just to show the monthly total would be super appreciated. Thanks.
Solved! Go to Solution.
@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
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:
the result like this:
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.
this worked beautifully
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.
@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
@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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |