Forum Discussion
2 Tables - show multiple options from one selection
Hi Garett52 ,
You need an extra table to list all unique IDs which will be added to slicer later, this table should be unrelated to both Table1 and Table2.
Slicer Item = DISTINCT(TB1[ID])
Add below measure to visual level filter.Measure = IF ( ISFILTERED ( 'Slicer Item'[ID] ), IF ( SELECTEDVALUE ( TB2[ID] ) IN { SELECTEDVALUE ( 'Slicer Item'[ID] ), SELECTEDVALUE ( 'Slicer Item'[ID] ) + 1 }, 1, 0 ), 1 )Best regards,Yuliana Gu
Microsoft EmployeeHi Garett52 ,
You need an extra table to list all unique IDs which will be added to slicer later, this table should be unrelated to both Table1 and Table2.
Slicer Item = DISTINCT(TB1[ID])
Measure =
IF (
ISFILTERED ( 'Slicer Item'[ID] ),
IF (
SELECTEDVALUE ( TB2[ID] )
IN { SELECTEDVALUE ( 'Slicer Item'[ID] ), SELECTEDVALUE ( 'Slicer Item'[ID] ) + 1 },
1,
0
),
1
)
Hi v-yulgu-msft
Thanks for your reply. I'm still very new to PowerBI so I apologize if this is simple but I have two follow-up questions. First, in my example Table1 has some visual level filters applied to show only certain ID's, would it be possible to create a table from that using a filter on one column that only shows three of the available codes for the reference slicer?
Second, is it possible to do this without a slicer by selecting the ID in the first table? Currently I can select (highlight?) a row in the first table and it will show me all the ID's in the second table.
Thanks again