Forum Discussion

MustafaP's avatar
MustafaP
Frequent Visitor
2 years ago
Solved

Select Slicer default yesterday with all dates showing

Hi Everyone, I need support for my report, it has data from 2023 till 2025. I have a date filter and i want to select automaticly yesterday in first openning but with all dates, user can change if ...
  • shafiz_p's avatar
    shafiz_p
    2 years ago

    I have check today and refreshed , It is still working for me. 

    Let's do it in other way. 

    Open power query: Before creating any steps, first sort the date column in ascending order. See image below:

     

    Create an index column starting from 1.


    Now do the steps to create only custom column to identify yesterday.

     

    Again create a condition custom column to sort the custom date column.

    Now remove the index column and change type of custom column to text and SortIndex column to whole number.

    Sort the sortindex column in ascending order, and close and load.


    Go to the table view and sort the custom column by SortIndex column.



    Hope this will work!!
    If this solved your problem, please accept it as a solution!!

    Best Regards,
    Shahariar Hafiz