Forum Discussion
Date slicer
I have a query regarding Power BI. I have a data that has start and end date . I am trying to create a slicer (Slider type) which has first input as a start date and other input as end date to ...
As you can see that data is from a single table
I am trying to create a slicer which has first input as a start date and other input as end date to filter the miles data. But I am facing the issue as slicer is applied on single column.Due to which I have to create two slicers ,one for start and other one for end date. I want both start and end date in one slicer.
As you can see between slicer has two date selection.What I want is that first box in that should take start date as input and other box should take end date as input
Please suggest me what to do in this case.
Hi shuklasuyash ,
You can create a date table in your data model, use the date column from it as slicer ,and then add filter(table,table[start date]>=MIN(Date[Date])&&table[end date]<=MAX(Date[Date])) to all measures you used in the report or add visual level filter. It's quite a big work.
As a workaround, I suggest you create two slicer , for start date you change the slicer to after mode for end date you can change the slicer to before mode. Please refer to https://radacad.com/from-and-to-date-slicers-in-power-bi-filtering-based-on-two-fields
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai