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 on date but It didn't work. You can find the screenshot below that the dates are not sorted properly.

 

Regards

Faiz

 

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.

8 Replies

  • 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.

     

  • writetofaiz's avatar
    writetofaiz
    Helper I
    4 years ago

    Hi,

     

    I cannot convert it to date type since of the values is "Current"

     

     

    Is there any other way to handle this scenario?

     

    Regards

    Faiz

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi writetofaiz ,

      Due to you have text value "Current" in this column, this column is in text format. Here I suggest you to add an Index column in Power Query, and then sort this column by Index column. So you need to convert the connection of the table which contains this column from Direct Query to Import. Power BI doesn't support us to add columns in Power Query in table connected by Direct Query. Or you can add an Index column in this table in SQL and load the new table into Power BI.

      Firstly add an Index start by 1. Then add a custom column by If function.

      New table should look like as below.

      Finally sory Date column by NewRank column in Report View.

      You may refer to this blog for more details.

      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.

      • writetofaiz's avatar
        writetofaiz
        Helper I
        4 years ago

        Hi,

         

        Your solution is close to what I am looking for, but when I tried to sort, I got the below error.

         

        As you can see in the data below, for same event date, there are multiple values in "New Rank" field.