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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Afaque_Eclerx
Frequent Visitor

To get only available values of column in a slicer

Hi 

I need help to create a slicer in a column where I have values -15,-10,-5,0,5,10,15. 

I want only these values in my slicer. But when I put this in slicer of Power BI the slicer also gives values other than the available on top.

 

For e.g. im getting -13 and 7 in slicer which is not available in column values.

Afaque_Eclerx_0-1692258021373.png

 

4 REPLIES 4
Afaque_Eclerx
Frequent Visitor

This is to be done in slicer only. That is the requirement.

mlsx4
Memorable Member
Memorable Member

Hi @Afaque_Eclerx 

 

Maybe if you change the style of your slicer, it would show only the desired values:

 

mlsx4_0-1692258853997.png

Instead of "Between", choose a "List"

 

The above requirement I want to implement in slicer only with between or grater than but the below bar to slide data should be available.

Hi @Afaque_Eclerx 

Then, you should take a look at the solution of this link and use parameters: https://community.fabric.microsoft.com/t5/Desktop/Number-Range-as-Slicer/td-p/1631043

 

Otherwise, you won't be able to do it

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

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.