filter dashboard for last input number of days

[Sankhadeep]

Hello All,

Please provide me the solution for the mentioned scenario :

I have created a custom parameter where user can input for LAST ___#___ DAYS(min 1 increment by 1 max 1000)

I have a AllotedDate column which have duplicate days.

When the user input for the last # of days, the whole page will filter till max of allotedDate from user input # of days. The dax should respond to any user input and filter the full page.

Relative date filter / any other visualization is not neeeded.

[v-cherch-msft · Accepted solution]

Hi @Sankhadeep

You may add below measures and use Filter measure in visual level filter.Attached the sample file for your reference.

LastNDay =
CALCULATE ( MAX ( Table2[AllotedDate] ), ALL ( Table2 ) ) - Parameter[Parameter Value]

Filter = IF(MAX(Table2[AllotedDate])>=[LastNDay],1)

Regards,

Cherie

[Sankhadeep]

Hi @v-cherch-msft,

I tried your soultion it didn't worked for me. Sorry for the late responce as I was out of station. 

It will be very much helpful if u can provide some other solutions/measures regarding this problem.

Note : I have some dropdown filters and other data card visuals as well which doesn't take visual level /report level filter for your soltuion.

Regards,

Sankhadeep