Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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 |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
84 | |
66 |