The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
I have a values in the slicer as displayed in a table, and there are two slicers, Slicer 1 and Slicer 2. Slicer 1 has an interaction with Slicer 2, but not the other way around. Initially, Slicer 1 is set to "A" and Slicer 2 is set to "1," as shown in the figure. When I change Slicer 1 value from "A" to "B," everything works fine. However, when I change Slicer 1 to "C," since Slicer 2 doesn't have any corresponding value as "1" it displays all blank visualization. Is there any setting that can automatically change Slicer 2 to "1+" in this situation?
Table
Slicer 1 | Slicer 2 |
A | 1 |
2 | |
B | 1 |
2 | |
3 | |
4 | |
C | 1+ |
2+ | |
3+ |
Initially
Slicer 1 | Slicer 2 |
A | 1 |
Current output
Slicer 1 | Slicer 2 |
C | 1 |
Expected output
Slicer 1 | Slicer 2 |
C | 1+ |
Thanks in advance
Solved! Go to Solution.
Hi @Omesh
Slicers can't natively "reset" when their selection becomes invalid.
However, there is a workaround involving field parameters. I have attached a small example.
I have assumed Slicer 1 & Slicer 2 only allow single selection. This can be relaxed for Slicer 2 without changing anything, but if relaxed for Slicer 1 it complicates things.
The basic idea is:
Please take a look at attached PBIX and see if that helps 🙂
Regards
Hi @Omesh
Slicers can't natively "reset" when their selection becomes invalid.
However, there is a workaround involving field parameters. I have attached a small example.
I have assumed Slicer 1 & Slicer 2 only allow single selection. This can be relaxed for Slicer 2 without changing anything, but if relaxed for Slicer 1 it complicates things.
The basic idea is:
Please take a look at attached PBIX and see if that helps 🙂
Regards
User | Count |
---|---|
28 | |
11 | |
8 | |
6 | |
5 |
User | Count |
---|---|
35 | |
14 | |
12 | |
9 | |
7 |