Select value on slicer based on value other slicer

[Namoh]

Hi all,

I've got the following issue.

I've got 2 slicers, each slicers is controlling the values of a Clustered Bar Chart.

One Chart shows Month data, the second shows YTD data.

Slicer one values are:

1 Deviation from Target Utilisation Downtime

2 Deviation from Target Planned Downtime

3 Deviation from Target Unplanned Downtime

4 Deviation from Target Speed Downtime

5 Deviation from Target Quality Downtime

6 Deviation from Target MTBF

Slicer two values are:

1 Deviation from Target Utilisation Downtime YTD

2 Deviation from Target Planned Downtime YTD

3 Deviation from Target Unplanned Downtime YTD

4 Deviation from Target Speed Downtime YTD

5 Deviation from Target Quality Downtime YTD

6 Deviation from Target MTBF YTD

So when I select option 1, graph 1 shows the values related to option 1, when I change to option 3 the values change to option 3.

Same applies for the 2nd slicer and the 2nd graph.

What I want is the following:

- when I select option 1 from slicer 1, I want automatically that slicer 2 also selects option 1 (and therefore shows the values of option 1 in graph 2)

- when I select  option 2 from slicer 1, I want automatically that slicer 2 also selects option 2 (and therefore shows the values of option 2 in graph 2)

- when I select  option 3 from slicer 1, I want automatically that slicer 2 also selects option 3 (and therefore shows the values of option 3 in graph 2)

- etc

-..

Is this possible, if so, how?

[v-deddai1-msft · Accepted solution]

Hi @Namoh ，

I suggest you combine these two slicer table into one, or you can create a visual level filter on the slicer two: 

Measure = IF(MAX(LossesYTD[Sort] IN VALUES(Losses[Sort])),1,0)

And set it is 1.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai

[amitchandak]

@Namoh , one slicer can reduce the value of another slicer but can force it to select a value 

refer how they can reduce the value

https://www.youtube.com/watch?v=cyOquvfhzNM