I drag slicer and add Month_paid field in that and convert that one to dropdown now month looks like
Feb , aPRIL , June , Jan , Dec
i want to sort these months in dropdown how i should do this
this is the link of sample file
https://www.dropbox.com/s/sp9zfyq2sccgmmi/Claims_test_model_2.pbix?dl=0
will you please check ?
You can create a "sorting" calculated column by using the following DAX (or something similar):
Month Sort =
MONTH(Claims_excel[CLM_LOSS_DT])
Once this has been created, right click on the Claims_excel[CLM_LOSS_MONTH] and click the 'Sort by' option and choose the new column.
This will produce the following results:
If you have actual dates in your field then create a calculated column using the following logic:
YearMonthSort = YEAR(Claims_excel[CLM_LOSS_DT])*100 + MONTH(Claims_excel[CLM_LOSS_DT])
You will need another integer column in that table with numbers 1 to 12 representing the order of the Months. You can create that column in either DAX or M. When created, just select the Month column and click on 'Sort By Column' option in the Modeling tab and select the integer column which was created.This will sort the order of the months in the slicer. If the month data in the column is already in an order starting from January to December then a simple Index column (from 'Add Column' tab in Power Query editor) is enough, else a calculated column which will check the month column value for each row and put the corresponding order number in the newly calculated integer column will be required. Refer this https://radacad.com/sort-by-column-in-power-bi
