Forum Discussion

snaraya's avatar
snaraya
Icon for Helper II rankHelper II
2 years ago

Custom slicer with conditional values

Hi All,

 

i have two columns Due Date Status & overdue within 5days created on the basis of one numrical calculated Days Overdue column which is created using date column.

 

Days Overdue = IF(ISBLANK(vw_mi[Due Date]),vw_mi[Due Date],DATEDIFF(vw_mi[Due Date],TODAY(),DAY))

older dates than today : positive value
future dates than today : negative values
same date as today : 0,
if blank then it should be blank
 

Due Date Status = SWITCH(TRUE(),ISBLANK(vw_mi[Days Overdue]),"No Due Date", vw_mi[Days Overdue]>0,"Over Due","Not Overdue") and

 

overdue within 5days = SWITCH(TRUE(),ISBLANK(vw_mi[Days Overdue]),BLANK(), vw_mi[Days Overdue]>=-5 && vw_mi[Days Overdue]<=0," Upcoming Overdue within 5days")

 

 

currently i am using Due Date Status as a slicer and Upcoming as button  , everything works fine .

 

now i want a single slicer with all this values. The problem i am facing is since Overdue within 5days being the subset of Not Overdue the values in table dont show right.

I want not overdue show both values of not overdue and overdue within 5days and overdue within 5days should show only its  filtered data.

No Due Date
Not Overdue
Over Due
Overdue within 5days

 

Everything is in same table 

 


any inputs is appreciated. thankyou 

 

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi snaraya

     

    I reproduced your formula with test data, and perhaps you could modify the Due Data Status formula to take the following form:

     

    Due Date Status =
SWITCH (
    TRUE (),
    ISBLANK ( 'Table'[Days Overdue] ), "No Due Date",
    'Table'[Days Overdue] > 0, "Over Due",
    'Table'[Days Overdue] >= -5
        && 'Table'[Days Overdue] <= 0, "Upcoming Overdue within 5 days",
    'Table'[Days Overdue] < -5, "Not Overdue"
)

     

     

     

    Is this the result you expect?
     

    Best Regards,

    Community Support Team _Yuliax

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

    • snaraya's avatar
      snaraya
      Icon for Helper II rankHelper II
      2 years ago

      Thankyou for this. And sorry for delay in response.

       

      I dont know if it possible or not but i want something in sense as when i click not overdue it should show me the upcoming ones as they are not overdue also and when i click upcoming in 5days then it should show only upcoming. 

      like all showing in upcoming should also be shown in not overdue also & upcoming 5days should show only upcoming in 5days.