Forum Discussion
Solved
Filter data as per slicer without timestamp properties
I have a table on a spreadsheet with the following data: Month January February Day Car Bus Trucks Car Bus Trucks 1 1507 69 0 730 43 100 2 2761 29 618 1024 21 79 ...
If I have understood the problem properly, then you should be able to resolve this by creating a new date column in Power Query using the day and month already present.
Then use this new column in your slicer, and change the settings to a date range, or "between".
If I have understood the problem properly, then you should be able to resolve this by creating a new date column in Power Query using the day and month already present.
Then use this new column in your slicer, and change the settings to a date range, or "between".
