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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
ashwinibh
Frequent Visitor

numeric range slicer - configurable

Hi, I am using power bi desktop and i want to show range values in the slicer.

And these range values need to  be configurable by the user.

Please let me know how can this be achieved.

 

Regards,

Ashwini

3 REPLIES 3
v-jiascu-msft
Employee
Employee

Hi, @ashwinibh

 

Could you please tell me what's this for? Because the field of a slicer is from a column of a table, we can't configure it. But there may be a workaround. We can group them in advance. Then we can create two slicers. One is for configuration, the other is for the values. You can have a look at the picture.

 numeric range slicer - configurable02.jpg

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

numeric range slicer - configurable.jpg

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Best Regards!

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

I have batchid column and I want a slicer to show ranges of these batchids.

But the ranges are not fixed user should be able to configure the range.

If there are batchids from 1 to 1000 in my table, user should be able to counfigure and set and range from 1-1000

for example he can select 1-500 or 501-1000,etc

Hi, @ashwinibh

 

I get it now. Users don't need to configure anything. In the latest version of PBI, the slicer has option "Between". The slicer will get all the range in the column. And you can choose the range by sliding the scale. Please have a try.numeric range slicer - configurable 2.jpg

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Best Regards!

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

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.