Forum Discussion
Slicer Manipulation
Hi All,
Firstly AnkitKukreja thank you for your solution!
And Aleria88 ,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!
Best regards,
Community Support Team_ Tom Shen
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
- Aleria881 year agoNew Member
I'll give it a try and let you know. Hopefully, it will work.