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
DataInsights's avatar
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's avatar
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.