Forum Discussion
Sum data by month in Stacked column chart
I have a Stacked column chart with a slicer:
Currently it is summing by date - I would like to sum by calendar months. So the latest column would be April-to-date, then previously March, and so on. Thanks for any pointers!
Create a month year column in Date table and You will also need a sort column
Month Year = format([date],"MMM-YYYY")
Month Year Sort = format([Date],"YYYYMM")
Make Month Year Sort as sort column of Month Year
https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column
1 Reply
- amitchandak
Super User
Create a month year column in Date table and You will also need a sort column
Month Year = format([date],"MMM-YYYY")
Month Year Sort = format([Date],"YYYYMM")
Make Month Year Sort as sort column of Month Year
https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column