Need to display Date range as per the TWO date slicers selection in line chart

[Kondla333]

Hi All,

I have line chart visuals and Two date slicers, one is Begin date slicer and other is End date slicer. 

Now i want to display date range as per the Begin date slicer selection and end date slicer selection in line chart viusuals. But when am selecting from begin date and end date selection it is showing all the avaialble dates in the line charts. Can anyone help me on this?

@tex628 , @Ashish_Mathur will you please help me on this?

Thanks in Advance 🙂

[Ashish_Mathur]

Hi,

Share some data (in a format that can be pasted in an MS Excel file.), describe the question and show the expected result.

[amitchandak]

@Kondla333 , You need independent date tables in slicer for that

Date Range Using 2 slicer =
var _max = minx(allselected(Date1), Date1[Date])
var _min = maxx(allselected(Date2), Date2[Date])
return
calculate(countrows(Table), Filter(Table,Table[Date] <=_max && Table[Date] >=_min) )

or with Date1, Date2 are independent and date joined to table

Date Range Using 2 slicer =
var _max = minx(allselected(Date1), Date1[Date])
var _min = maxx(allselected(Date2), Date2[Date])
return
calculate(countrows(Table), Filter(Date,Date[Date] <=_max && Date[Date] >=_min) )

refer similar case

Select data between months - https://youtu.be/nEt7dT3Tfv4