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,...
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
amitchandak
Super User
Super UserCreate 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