Creating a date slicer

Power BI
1

in my table there is a run_date_time column which has dates like:
2023-12-20 06:32:53
…
In transform section, I add a column by example so that I have only date and I named the column as run_date_format

Then in the power bi page, I select the slicer and select the run_date_format column. so I see a list of checkboxes with dates. I would like to have a date range slicer.
When I click on the Field drop down of the slicer, I do not see the option for date hierarchy and so can not convert the check box slicer to a range slicer.
Any suggestions?
thank you

2

I worked it out.
I had to make sure the date is indeed a date format and not a text
thanks

1 Like
3

Just as a reminder, when working with date columns in Power BI, it’s a good practice to ensure that the data type of the column is set to “Date/Time” in the Power Query Editor. This helps Power BI recognize the column as a date, allowing for various date-related functionalities, including the date hierarchy and range slicer.