Show data based on two slicers (Start_Date and End_Date)

[Telmoogc]

Basically I have two slicers, one for the start date and the other for the end date. The aim is for the user to be able to define the date range and only view the dashboard data within that range.

I've seen several posts about defining a date range, but they were always options with just one slicer, and I wanted to avoid that option as much as possible

[Anonymous · Accepted solution]

Hi @Telmoogc ,

I create a table as you mentioned.

If you want to use two slicers, I think you can create two new tables.

Table = CALENDAR(MIN('T2'[Start Date]),MAX('T2'[End Date]))

Then you can do what you want to do.

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ryan_mayu]

even if you have one slicer for start date and the other slicer for end date, that's the same as selecting the start and end date in a date range filter. Could you pls clarify your request? It's better to provide some sample data and expected output.

[Selva-Salimi]

hi @Telmoogc 

It is not that much clear for me what you exactly want to calculate. but based on my understanding, you have two Date dimension and a fact table (lets assume to calculate sale). One of the easiest ways that I recommend is to use a measure as follows to calculate sales between selected range:

measure sales_amount := 

var start_date := min( date1_table [date])

var end_date := max (date2_table [date])

return

calculate (sum(sales) , filter ( sales_table , sales_table [date] >= start_date && sales_table [date] >= end_date))

keep in mind that there should not any relationship between these tables!!

If this post helps, then I would appreciate a thumbs up 👍 and mark it as the solution to help the other members find it more quickly. 

[RichardJ]

Hi @Telmoogc  - if you use use a slicer with your date in it you can set up the slicer to enable the user to enter a start date and an end date like this


The options here are
Slicer
and 'Between' as style



If it needs to be two slicers you can have one slicer 'before' the date and one slicer 'after the date on the same tab then the date range between the two dates will be shown.