Getting Data from slicer to automatically impact table visual without clicking

[adnijasure]

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 ShiftType slicer (done)

2. Create Position slicer (done)

3. ShiftType Slicer filters Position slicer. (edited interactions) (done)
4. Create a table visual to show all the the ShiftTypes for the positions in the Postions Slicer (need help)

Example: 
ShiftType = First
Position Slicer contains: 1,2,3,5
Table visual should show all the ShiftTypes for positions 1,2,3,5.

Method 1:
Interactions: 
* ShiftType slicer filters Position Slicer, does NOT filter table visual

* Positions Slicer only filters table visual
Problem: 
I have to manually click on all the Positions in the Position Slicer to see all ShiftTypes for those positions. 
I want to the table visual to automatically filter based on the Positions in the Position Slicer wihout having to select them indiviudally. 

Method 2 (prob doesn't work):
Potentially create a calculated table or use New Measures??

[v-cgao-msft]

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]

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.

[DataInsights]

@adnijasure,

Is this the expected result? This is default behavior (Edit Interactions is enabled between visuals).

[adnijasure]

Hey! 

The results should show all the ShiftTypes for given positions. For example if you selected ShiftType First, Positions 1,2,3,5 have ShiftType First. Now in my table I want to show all the ShiftTypes for positions 1,2,3,5 only. 

[DataInsights]

@adnijasure,

Thanks for clarifying. You'll need a disconnected table (no relationships); this can be created in Power Query or DAX.

Create the measure below:

Shift Type Filter = 
VAR vSelectedPosition =
    VALUES ( Position[Position] )
VAR vShiftTypeSelectedPosition =
    FILTER (
        'Position Disconnected',
        'Position Disconnected'[Position] IN vSelectedPosition
    )
VAR vResult =
    SUMX ( vShiftTypeSelectedPosition, 1 )
RETURN
    vResult

Add this measure as a visual filter to a table visual:

In the table visual, add ShiftType from the disconnected table.

-----

[adnijasure]

@DataInsights sorry for any confusion, I appreciate all the help. Let me go into more detail about what my expected output is and what I have tried so far. 

Raw Data (raw_data):

First Step - Create a ShiftType Slicer

Second Step - Create a Position Slicer

Third Step - Create table visual with positions and ShiftType

My thought process:

Connections: 
ShiftType slicer: Only Filters the Positions Slicer, doesn't filter the table visual in Third Step

Position slicer: Only Filters the table visual in Third Step

Example case (Third ShiftType): 

The Position Slicer filters correctly, however, the table visual shows all the Positions and all ShiftTypes. I only want to see the All the ShiftTypes for Positions 1,3,4. 

Expected Output:

The expected output only displays when I select the Positions in the Position Slicer. This is an inefficient way becasue if I had multiple 100 Positions it would be ineffcient to click on all of them. 

I want to find a way for the table visual to show all the Positions in the position slicer and all the ShiftTypes for those positions wihthout having to select the each position in the Positions Slicer. 

Hope this brings some more clarity 🙂 

[DataInsights]

@adnijasure,

If you enable interactions between the ShiftType slicer and table visual, selecting a ShiftType will 1) filter the Position slicer (interactions already enabled) and 2) filter the table visual for the selected ShiftType. Selecting all values in a slicer is the same as selecting no values in a slicer, so there's no need to select all values in the Position slicer after selecting a ShiftType.

[adnijasure]

@DataInsights sorry for the confusion, I appreciate all the help. Let me explain the process in more detail and provide images for clarity. 

Dataset (Raw_Data): 

First step: Create a ShiftType slicer

Second Step: Create Positions Slicer

Third Step: Create a table visual that contains Position and ShiftType as columns

My thought process: 
Connections: 

• ShiftType slicer: Filters positions only, does NOT filter table visual in the third step. 
• Position slicer: Filters the table visual only

I was under the impressions that since ShiftType slicer is only affecting the Positions Slicer and not the table, and that the Position slicer is only affecting the Table Visual, that all the positions in the Position Slicer would show up in the Positions in the Table Visual. 

Example: 
If I select third ShiftType, the Positions filter should only have Positions 1,3,4 (which it does). However, the table visual shows all the position numbers. 

EXPECTED OUTPUT:

The expected output which shows all the Shifts for the Positions in the Positions slicer only show when I select all of the positions in the Position Slicer. 

What I want to happen is for that to happen but by not having to select all the Positions in the Position Slicer becasue it is inefficient, I could have 100+ positions and it would be inefficient to click all of them individually.