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.

     

     

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 )