Order Date function not on display in View Table (Power BI)

Hi Cke ,

Month is the function order date is the column in the table used in the video .

to get the month number you need to use the 

Month = month(financials[Date])

 

make sure the Date is in the correct date datatype 

https://learn.microsoft.com/en-us/dax/month-function-dax

Thanks 

If this response was helpful in any way, I’d gladly accept a kudo.
Please mark it as the correct solution. It helps other community members find their way faster.

Hi Cke  can you use the sort by columns option. 

Select the column thats used in the button slicer then sort by month. Number this should resolve the sorting issue