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
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
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.
Thank you so much Natarajan_M :).
I have another question related, please:
I am using a button slicer to filter or control the bar chart you can see in the picture. However, the date format includes the full date (day/month/year). There is any method for the name of the month to appear instead of the full date, just as in the bar graph?
Thank you so much in advance
Hi,
Create this calculated column in the Calendar table
Month name = format(calendar[date],"mmmm")
Thank you,
However, in the resultant button months are not chronologically organized, so I got back to my initial question.
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
