Sum data by month in Stacked column chart

[Anonymous]

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!

[amitchandak · Accepted solution]

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