How to remove to blank values from slicer and sort on month names??

[apentyala]

Hi All,

I created a slicer with MonthNames and it has balnk values and I were placed column page filter and removed balnks but the problem was when remove the balnk from column the slicer default value (All) is not showing?? I want display All is default value in slicer??

2) how to sort Month Names in order (JAN,FEB..)?? cretaed Date table using DAX.

Regards,

Avinash

[Anonymous]

Hi @apentyala,

I think both issues would be resolved in your Date table. 

1. There should be no dates without a month.

2. Add a Month Sort column, with a number value equal to the month of year. Then do the following for the Month Name column: