Set date filter from and to in a report

[ABill234]

Hi All,

Wondering if someone can help, how to I set a to and from date as a visualisation? 

I know you can have one selected date on a slicer but not from say 1/10/2020 - 1/11/2020

Thanks in advance

[FarhanAhmed]

you can do it by putting date in Slicer visual and then you have option to select Between or any other criteria you wanted.

[ABill234]

Hi @FarhanAhmed How do I get this?

[FarhanAhmed]

Under Visualization pane, you can see this visual

[ABill234]

This is a slicer on mine? and brings down the dates in a list or dropdown not slider? How do I get it to be a slider like your screenshot in previous message? @FarhanAhmed 

[FarhanAhmed]

Your column should have data type as "DATE",

Once you select the slicer Visual and put that column in the Slicer Visual. then you need to click below

[ABill234]

@FarhanAhmed am i doing something wrong? 

[FarhanAhmed · Accepted solution]

1- Select the date field in table

2- goto Column Tools ribbon and see if the data type is date

3- If it is not date change it to date

4- check the slicer and select between from drop down

[ABill234]

thank you! @FarhanAhmed 

[amitchandak]

@ABill234 , what I got is you want outside the range

if the slicer table is an independent table

measure =
var _max =maxx(allselected(date),date[date])
var _min =minx(allselected(date),date[date])

return
calculate(Sum(TABLE[DATE_FIELD_2] ), filter(Table, Table[Date] >=_max && Table[Date] <=_min))

if joined with table
measure =
var _max =maxx(allselected(date),date[date])
var _min =minx(allselected(date),date[date])

return
calculate(Sum(TABLE[DATE_FIELD_2] ), filter(all(date), date[Date] >=_max && date[Date] <=_min))

[ABill234]

Hi @amitchandak Thanks for this ! where do I put the return? / measure? 

Sorry im new to this! can you send screenshot if you wouldnt mind?

[amitchandak]

@ABill234 , not very clear. if you wnat to know how to create a measure , refer

https://www.youtube.com/watch?v=TQhN1xfV1fo