Forum Discussion
Getting Data from slicer to automatically impact table visual without clicking
Is this the expected result? This is default behavior (Edit Interactions is enabled between visuals).
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.
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 vResultAdd this measure as a visual filter to a table visual:
In the table visual, add ShiftType from the disconnected table.
-----
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 columnsMy 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.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 StepPosition 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 🙂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.