Forum Discussion

SamuelMei's avatar
SamuelMei
Regular Visitor
6 years ago
Solved

Partial filtering by slicer

Hi everyone,

 

This might be a stupid question but

 

I have a dashboard showing product information. The product is selected by by selecting a ProductID with a slicer. 

 

By selecting the ProductID in the slicer, I automatically select the Product Group, Device Family, etc. 

 

The problem is that now I am trying to add a table that shows similar products to the selected product, i.e. show ProductIDs of products that belong in the same Product Group and Device Family.

 

One way to do it is to first unlink the interaction between the original slicer and the new table. Then, have multiple slicers for just the Product Group and Device Family to filter the table. This achieves the purpose, but requires the user to check many more boxes than they should be required to do. Hence this method is not ideal. 

 

Any help is much appreciated. 

 

 

Need Help
  • V-lianl-msft's avatar
    V-lianl-msft
    6 years ago
     
    Based on your description, you want to filter the productid with slicer. Then display the productid of the same Product Group, Device Family with another chart.
    First, you can copy the table, then create a measure and add measure = 1 as a condition to visual filter.
    Please refer to the pbix.

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

3 Replies

  • V-lianl-msft's avatar
    V-lianl-msft
    Icon for Community Support rankCommunity Support
    6 years ago
     
    Based on your description, you want to filter the productid with slicer. Then display the productid of the same Product Group, Device Family with another chart.
    First, you can copy the table, then create a measure and add measure = 1 as a condition to visual filter.
    Please refer to the pbix.

    Best Regards,
    Liang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
    • SamuelMei's avatar
      SamuelMei
      Regular Visitor
      6 years ago

      V-lianl-msft  Thanks for your answer. Sadly my organization is still running Power BI Janurary 2019 so I could not open your pbix. I have duplicated the table, but can't seem to figure out the DAX for the measure. Could you please upload the DAX? Thanks very much.

       

      Edit: i have figured it out. Thank you V-lianl-msft 

      • V-lianl-msft's avatar
        V-lianl-msft
        Icon for Community Support rankCommunity Support
        6 years ago
        Hi SamuelMei
         
        You can refer to the DAX:

         

        Measure = IF(MAX('Table'[product_group])=SELECTEDVALUE(Sheet1[product_group])&&
            MAX('Table'[Device Family])=SELECTEDVALUE(Sheet1[Device Family]),1,0)

         


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