Getting Data from slicer to automatically impact table visual without clicking

adnijasure
Regular Visitor
1 year ago
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
  Super User
  1 year ago
  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
    Regular Visitor
    1 year ago
    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.