Forum Discussion

adnijasure's avatar
adnijasure
Regular Visitor
1 year ago

Getting Data from slicer to automatically impact table visual without clicking

Test Dataset: Position ShiftType 1 First 1 Second 1 Third 2 First 2 Second 3 First 3 Third 4 Second 4 Third 5 First 5 Second 1. Create ShiftTy...
Need Help
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi adnijasure ,

 

Try creating an unconnected table:

And the new measure:

Measure = 
VAR __positions = VALUES('Table'[Position])
VAR __shift_types = CALCULATETABLE( VALUES(Table2[ShiftType]), 'Table2'[Position] IN __positions)
VAR __curr_shift_types = SELECTEDVALUE('Table2'[ShiftType])
VAR __filter = IF( __curr_shift_types IN __shift_types, 1)
RETURN
    __filter

Use the fields in Table 2 to create a table visual and apply the measure just created to the visual filter:

 

Best Regards,
Gao
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

adnijasure's avatar
adnijasure
Regular Visitor
1 year ago

Hey, 


Unfortunately that is not the correct output. As you slected ShiftType First, the position slicer is correct. However, in your Table visual with the measure column, Position 4 is included. Whereas it should only be showing all the ShiftTypes for positions 1,2,3,5.