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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
Super User
Super User

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

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.