Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
sahgir123
Frequent Visitor

want see output according to slicer selection

ValueBelow 6Below 0

10  
9  
8  
7  
6  
5Below 6 
4Below 6 
3Below 6 
2Below 6 
1Below 6 
0Below 6 
-1Below 6Below 0
-2Below 6Below 0
-3Below 6Below 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

3 REPLIES 3
ChiragGarg2512
Solution Sage
Solution Sage

@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.

ChiragGarg2512_0-1696528119006.png

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.

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors