Slicer Manipulation

Question

I have been search for 2 days on how to get this to work and none of the videos I have watched pertain to my need. I don't know if my ask is too complicated but here goes. I have two slicers. One has Production Line options and the other has Shift Options. Some production lines have two shifts and the others have one shift. I want the Shift Slicer to only show 1st Shift when certain Production Lines are selected and 1st Shift and 2nd Shift for when the others are selected.&nbsp;&nbsp;These Slicers come from two tables that don't have a relationship. So, this is the formula I used in the measure...ShowShift = VAR SelectedLine =&nbsp; &nbsp; SELECTEDVALUE ( ProductionLines[ProductionLine] )RETURN&nbsp; &nbsp; IF (&nbsp; &nbsp; &nbsp; &nbsp; SelectedLine = "Fleetline"&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &amp;&amp; TREATAS ( { "1st Shift", "2nd Shift" }, Shifts[Shift] ),&nbsp; &nbsp; &nbsp; &nbsp; 1,&nbsp; &nbsp; &nbsp; &nbsp; IF (&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SelectedLine = "Truckline"&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &amp;&amp; TREATAS ( { "1st Shift", "2nd Shift" }, Shifts[Shift] ),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; IF (&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SelectedLine = "HCL"&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &amp;&amp; TREATAS ( { "1st Shift" }, Shifts[Shift] ),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; IF (&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SelectedLine = "Minute Miser"&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &amp;&amp; TREATAS ( { "1st Shift" }, Shifts[Shift] ),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; IF (&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SelectedLine = "Stock Chaser"&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &amp;&amp; TREATAS ( { "1st Shift" }, Shifts[Shift] ),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; IF (&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SelectedLine = "Titan"&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &amp;&amp; TREATAS ( { "1st Shift" }, Shifts[Shift] ),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )))))))&nbsp;If someone can help me I would greatly appreciate it. If not, they'll have to deal with an extra option. At this point, I don't care anymore.

ankitkukreja · Answer

Hi!&nbsp;Aleria88&nbsp;
&nbsp;
Can you share the sample data from the tables, and share the expected outcome. Please make sure to hide your PII data before sharing. A sample of 10-20 rows should suffice.
&nbsp;
&nbsp;
&nbsp;
&nbsp;

anonymous · Answer

Hi All,Firstly AnkitKukreja&nbsp;thank you for your solution!And&nbsp;Aleria88&nbsp;,What I'm thinking is that if you want to dynamically affect the shift filter by using the proudction line filter, I think it's possible to do so.I think this is possible, I have tried to create some sample data myself, hopefully this will help you understand my thinking, and hopefully my approach will solve your problem.
ShowShift = 
VAR SelectedLine = SELECTEDVALUE(_Production_Lines[ProductionLine])
RETURN 
    IF (
        SelectedLine IN {"Fleetline", "Truckline"},
        IF (VALUES('Shifts'[Shift]) IN {"1st Shift", "2nd Shift"}, 1, 0),
        IF (VALUES('Shifts'[Shift]) = "1st Shift", 1, 0)
    )
After writing the MEASUREMENT, we put the MEASUREMENT into the FILTER in the shift silicer to exclude the value of 0, and we are ready to fulfill your needs.

I hope my thoughts help you solve your problem, if you have further questions, feel free to contact me and I will get back to you as soon as I receive the message!
Hope it helps!
&nbsp;
Best regards,Community Support Team_ Tom Shen
&nbsp;
If this post helps then please consider&nbsp;Accept it as the solution&nbsp;to help the other members find it more quickly.
&nbsp;
&nbsp;

aleria88 · Answer

I'll give it a try and let you know. Hopefully, it will work.

Forum Discussion

Slicer Manipulation

3 Replies

Related content

Stored Procedure to Manipulate Tables

Manipulate Data

Table Visual Manipulation

Manipulating slicer values with single column tables

Slicer