Selected Date

[BishwaR]

Hi,

I have a table like this:

Item Purchase  Today's Date   Payment Required Date  Payment Due Days

abc                   4/26/2021          4/27/2021                          -1

mky                  4/26/2021          4/26/2021                           0

klk                    4/26/2021           4/25/2021                          1

xyz                    4/26/2021           4/24/2021                         2

uiu                   4/26/2021            4/23/2021                         3

I have created a slicer "Payment Due Days" with the selecledvalues 1,2,3,4 etc

when I select 1 it shows all the records with the Due Days1 when I select 2 it shows all the Dues day 2

But what I am trying to achieve is when I select 1 it should show every days greater than 1 for example Day 1 Day 2 Day 3 records till the minimun date in the dataset.

Please help me

Thanks

Bishwa

[StefanoGrimaldi · Accepted solution]

it should let you directly input the value cause the selectvalue would be a text type parameter when you want a numeric parameter on this filter type/option

[BishwaR]

Thanks for your help. I tried it.  If I select the Payment Due Days 3 it shows upto the due days 3. But in my case,  it should be just the opposite. It should show due days 3,4,5,6 for the rest of the due days between 3 and the end of the due days.

[BishwaR]

I figured it out. I took the less than and equal to option Thanks

[StefanoGrimaldi]

hey, 

just add a filter and add the payment due days (column should be set up as numeric column) and theres a option in the filters tpe that let you select greater tham*

[BishwaR]

But it does not give me the selection option. I should be able to select the days from the slicer which have created using the selectedvalue dax