Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to 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
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
@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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
116 | |
104 | |
77 | |
71 | |
50 |
User | Count |
---|---|
145 | |
108 | |
107 | |
90 | |
65 |