date/time slicer( if I have many direct queries (KQL & SQL) in the same report and fromdate & todate

[Anonymous]

I have a power bi report contains many queries (direct queries from KQL & SQL) and I have two columns (fromdate & todate) so in the report I have to create two slicers (fromdate) and todate . then the only option is to select from the drop down slicers . how can I have one slicer only instead of the two slicers 

[barwe]

You need only one Date table.

Thats the all tables, no connections: 

DimDate = CALENDARAUTO()

MaxFilter = IF(Selectedvalue('FactTable'[todate]) <= CALCULATE(MAX('DimDate'[Date])),1,0)

MinFilter = IF(Selectedvalue('FactTable'[fromdate]) >= CALCULATE(MIN('DimDate'[Date])),1,0)

Now you can have only one slicer: 

[Anonymous]

I did the same, still the slicer is not active 

[barwe]

You probably can see only drop down because you are using "date hierarchy" no "Date"

Not sure if this is the best solution it should work:

1. Create an new teble "DimDate" that contains date column.

2. Then create a slicer with that DimDate[date].

3. Add 2 extra measures that will chacek what max and min value from "DimDate" are and comare them to your date columns.

MinFilter =IF(Selectedvalue('Your_Table'[fromdate]) >= CALCULATE(MIN('Table'[Date])),1,0)
MaxFilter =IF(Selectedvalue('Your_Table'[todate]) >= CALCULATE(MAX('Table'[Date])),1,0)
4. Add those filters to the visual and set them to  1

[Anonymous]

thank you for your feedback, I choose date not date hierarchy , could I know how to create DimDate 

in the fromdate I'm using 

FromDates = CALENDAR(date(YEAR(TODAY())-1,MONTH(TODAY()), 1), TODAY())

and todate

ToDates = CALENDAR(date(YEAR(TODAY())-1,MONTH(TODAY()), 1), TODAY())