Forum Discussion
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 theMonth = month(financials[Date])make sure the Date is in the correct date datatype
https://learn.microsoft.com/en-us/dax/month-function-dax
ThanksIf 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
Super UserCke MonthName will be sort alphabetically by default.
To sort by number of month you should have a column in your table with the corresponding month number (MONTHNUMBER); then select the column that has the name of months (MONTHNAME) column... finally, in the ColumnTools Select "SortByColumn">[select the column that has the corresponding month numbers]
This should be enough to enable the sort as you wanted, please go back to your viz and check if it works as expected
I hope this helps, if so please mark it as a solution, kudos are welcome.
thank you so much for your answer, I cannot mark it as the solution because another person gave me the solution before. However, your answer is quite elaborated š