Forum Discussion
Getting Data from slicer to automatically impact table visual without clicking
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.
-----
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 🙂
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.