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
almost done but sorting not worked.
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
- MustafaP2 years agoFrequent Visitor
thank you so much...