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.