Forum Discussion

jostnachs's avatar
jostnachs
Helper IV
1 year ago

Slicer issue

Hi All.... I have a requirement i am struggling with...

 

I have logic as below as a slicer to divide my activities. 

 

But the problem is if the activity followupstartdate is 5th feb and today is 16th feb, and if the closed status is not equal to s or u it has to fall under 2 categories.(Open & Due now ,Open & 7+days past due). but as per below screen shot t falls under due now. how do i acheive it? i.e when i select any option between these two below i should be able to see that activity.

 

 

Help please!

Need Help

4 Replies

  • Wilson_'s avatar
    Wilson_
    Memorable Member
    1 year ago

    jostnachs,

     

    I'm guessing your logic is a calculated column? In any case, one DAX calculation can't return two different values. My first question is why would your slicer criteria not be mutually exclusive? Why would one item fall under multiple statuses?

    • jostnachs's avatar
      jostnachs
      Helper IV
      1 year ago

      What do you mean by mutually exclusive... sorry i dont get it.

      • Wilson_'s avatar
        Wilson_
        Memorable Member
        1 year ago

        jostnachs,

         

        Why would your slicer criteria not be mutually exclusive, meaning I would suggest having slicer options (ex: A, B, and C) where one activity must be either A, B, or C and cannot be more than one of A, B, and C at the same time.

         

        Let me know if I should explain further or differently!


        ----------------------------------
        If this post helps, please consider accepting it as the solution to help other members find it quickly. Also, don't forget to hit that thumbs up and subscribe! (Oh, uh, wrong platform?)

         

        P.S. Need a more in-depth consultation for your Power BI data modeling or DAX issues? Feel free to hire me on Upwork or DM me directly on here! I would love to clear up your Power BI headaches.

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi jostnachs ,
    You can try the following code

     

    DueStatus = 
VAR TodayDate = TODAY()
VAR ClosedDate = V_DimActivities[FollowupStartDate]
VAR ClosedStatus = V_DimActivities[ClosedStatus]
VAR DaysDifference = DATEDIFF(ClosedDate,TodayDate,DAY)
RETURN
IF(
    ClosedStatus <> BLANK() && (ClosedStatus = "S" || ClosedStatus = "U"),
    "Closed",
    IF(
        ClosedStatus <> BLANK() && ClosedStatus <> "S" && ClosedStatus <> "U",
        IF(
            DaysDifference > 7,
            "Open & 7+days past due" ,
            IF(
                DaysDifference >= 0,
                "Open & Due now"
            )
        )
    )
)

     

    Turn on multi-select in slicer settings


    Final output

     

    Best regards,
    Albert He

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