Forum Discussion

writetofaiz's avatar
writetofaiz
Helper I
4 years ago
Solved

Sorting Date Slicer in Power BI

Hi, I have a power BI dashboard whose source is a sql query. Including date field, there are other fields in the query. Is there any way we can sort 'Date Slicer ' in Power BI? I tried sorting query...
Need Help
  • writetofaiz's avatar
    writetofaiz
    4 years ago

    I have created a seperate date table and joined it with the main table to resolve the issue. Thanks for all your help.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi writetofaiz 

You can select [Date] column and check the Data type in Column Tools. Please check whether your date column in slicer is date type or text type. 

Here I have a test to get data from SQL by Direct Query and you can see that my [Date] column is in Date type.

You can sort date type column by click "..." icon right above slicer. If your Date column in in date type, it will sort in right way.

 

Best Regards,
Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.