Forum Discussion

VipinReddy's avatar
VipinReddy
Icon for Microsoft Employee rankMicrosoft Employee
5 years ago
Solved

Filter slicer based on other slicer selection

Hi,    I have a requirement were the client wants to filter the slicer using an other slicer. I have three slicers Year, Month and Project Status as shown below.  The requirement is only whe...
Need Help
  • v-xiaotang's avatar
    v-xiaotang
    5 years ago

    Hi VipinReddy 

    You can make the following adjustments on parry2k's measure,

     

    Project Selected = IF ( SELECTEDVALUE ( 'Table'[Project Status] ) = "Completed", 1,0 )

     

    then put the measure into the visual level filter,

    result

     

     

    Best Regards,

    Community Support Team _Tang

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

     

     

parry2k's avatar
parry2k
Icon for Super User rankSuper User
5 years ago

VipinReddy create a measure as below and then use it as a visual level filter in other slicers  where the value is equal to 1

 

Project Selected = IF ( SELECTEDVALUE ( ProjectTable[ProjectColumn] ) == BLANK(), 0, 1 )

 

Tweak the above measure as you see fit.

 

✨ Follow us on LinkedIn

 

Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

 

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

VipinReddy's avatar
VipinReddy
Icon for Microsoft Employee rankMicrosoft Employee
5 years ago

In the measure you have provided there is no reference to the project status as complete. My requirement is when user selects project status as completed only then he gets to filter using Month and year. I the user selects staus as all or any other than completed then the month and year slicer should be blank. 

  • v-xiaotang's avatar
    v-xiaotang
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi VipinReddy 

    You can make the following adjustments on parry2k's measure,

     

    Project Selected = IF ( SELECTEDVALUE ( 'Table'[Project Status] ) = "Completed", 1,0 )

     

    then put the measure into the visual level filter,

    result

     

     

    Best Regards,

    Community Support Team _Tang

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

     

     

    • Decal's avatar
      Decal
      Icon for Helper I rankHelper I
      2 years ago

      I know this is sooo close to solving what I need, but I can't figure out how to apply.  How would you use this if your dropdown had 3 options?  In my case it's "full time", "part time", "per diem".  If "per diem" is not selected I want to drive a 1 so that I can use that for the visual filter.

      • idkwhatimdoing's avatar
        idkwhatimdoing
        Icon for Advocate I rankAdvocate I
        1 year ago
        Employee Type Selected = 
SWITCH ( SELECTEDVALUE ( 'Table'[Employee Type] ), "full time", 0, "part time",0,1 )