Forum Discussion

rena9994's avatar
rena9994
Frequent Visitor
6 years ago

Filter a disconnected table with a slicer

Following suggestions of submitting a question, this is an improved version of my original question: https://community.powerbi.com/t5/Desktop/Display-two-rows-with-multiple-column-values/m-p/1103049#...
Need Help
v-xicai's avatar
v-xicai
Icon for Community Support rankCommunity Support
6 years ago

Hi rena9994 ,

 

You can create measure Filter1 like DAX below ,then put measure Filter1 in the Visual Level Filter of table visual displaying the disconnected table , and setting the Filter1 as "is not blank".

 

Filter1 = IF(MAX([Slicer])=0,1,BLANK())

 

 

 

 

 

 

 

 

Best Regards,

Amy 

 

Community Support Team _ Amy

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

  • rena9994's avatar
    rena9994
    Frequent Visitor
    6 years ago

    Amy, thanks for your reply. That's the last part and I have a good handle on that part already. The part I have a problem with is changing the Slicer value in the disconnected table from PID to 0, once the PID is selected from the slicer that filters the two connected tables

    .

    • v-xicai's avatar
      v-xicai
      Icon for Community Support rankCommunity Support
      6 years ago

      Hi rena9994 ,

       

      You may create an intermediate table like DAX below, create relationships with your original two tables, then put 'Intermediate Table'[PID] into slicer visual to filter the other two tables.

       

      Intermediate Table = UNION(DISTINCT(Table1[PID]), DISTINCT(Table2[PID]))

       

      Best Regards,

      Amy 

       

      Community Support Team _ Amy

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