Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 |
---|---|
77 | |
75 | |
46 | |
31 | |
28 |
User | Count |
---|---|
99 | |
91 | |
51 | |
49 | |
46 |