Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
ValueBelow 6Below 0
10 | ||
9 | ||
8 | ||
7 | ||
6 | ||
5 | Below 6 | |
4 | Below 6 | |
3 | Below 6 | |
2 | Below 6 | |
1 | Below 6 | |
0 | Below 6 | |
-1 | Below 6 | Below 0 |
-2 | Below 6 | Below 0 |
-3 | Below 6 | Below 0 |
i have created slicer using filed parameter, if i select below 6 from slicer it should show
value which less than 6 like 5,4,3,2,1,0,-1,-2,-3
And if i select below 0 from slicer it should show -1,-2,-3
@sahgir123 If you want something like this, then create two columns using if statement and use those column in field parameters. After creating the parameter use that in a slicer.
Thank You.
want only one column in table visual, that is value column, if we select below 6 from slicer then it should show below 6 value like 5,4,3,2,1,-1,-2,-3 and if we select below 0 then it should show -1,-2,-3
@sahgir123 That is what the slicer in middle and right are doing. But if nothing is selected then both the column measures will be displayed. The image shows 3 pairs of slicers and table visual, these 3 pairs are not dependent on each other.
User | Count |
---|---|
98 | |
90 | |
83 | |
70 | |
67 |
User | Count |
---|---|
113 | |
104 | |
101 | |
73 | |
65 |