Forum Discussion
Select Slicer default yesterday with all dates showing
- 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
Hello MustafaP ,
You can create Conditional Column like the below and add it as filter in the filter section to restrict dates till yesterday..
If you find this helpful , please mark it as solution and Your Kudos are much appreciated!
Thank You
Dharmendar S
- MustafaP2 years agoFrequent Visitor
But i want to report came with yesterday selected.
- dharmendars0072 years ago
Memorable Member
Hello MustafaP ,
You can try with the below Calculated column, this is dynamic and use this as Filter.Condition = IF(TODAY()-1=Dates[Dates], "True", "False")If you find this helpful , please mark it as solution and Your Kudos are much appreciated!
Thank You
Dharmendar S