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
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
thank you so much!
Cke 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 🙂
Cke 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]1. MonthNumber Column:
2. SortByColumn
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.
