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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
elois33
Helper I
Helper I

Numeric slicer : show equal or greater values

Hello, 

 

I have one more issue with my dashbord and more specificaly with the numeric slicer. I have 2 numeric slicer, one for weight and the other for lenght as pictured bellow

 

Capture d’écran 2022-11-21 093005.png

These numeric slicers are:  

LENGTH = GENERATESERIES(0,500)
WEIGHT= GENERATESERIES(0,500)

Once the users insert values to each slicer, I want only to show equal or greater values on the matrix table that follows. 

 

Until today I use this messure: 
 
For length values: 
CouponLEN = VAR MINValue= MIN('LENGTH'[Value]) VAR MAXValue= MAX('LENGTH'[Value]) VAR CurrentValue= [lenght_capacity] RETURN IF(CurrentValue >= MINValue && CurrentValue<=MAXValue, 1,0)

 

For weight values:

CouponWE = VAR MINValue= MIN('WEIGHT'[Value]) VAR MAXValue= MAX('WEIGHT'[Value]) VAR CurrentValue= [weight_capacity] RETURN IF(CurrentValue >= MINValue && CurrentValue<=MAXValue, 1,0)
 

And then in the filters section I choose to show COUPONLEN and COUPONWE =1

 

The problem is that it is not that accurate. Everytime I have inferior values that comes by on the table. For example: 

 

Capture d’écran 2022-11-21 095250.png

In this table I want to have the length and weight values by mission and by day. But these values I want them to be equal or greater to the numeric slicers on the top.

I think it takes into consideration the Length and Weight capacity of the week and not the day.

 

What do you think? 

 

Thank you for your help 🙂

3 REPLIES 3
elois33
Helper I
Helper I

@v-yalanwu-msft thank you for your help! Here is a sample of my file. https://drive.google.com/file/d/1NA8t4UOxLVZQil9HmEYT0GJRKBXuzl6-/view?usp=sharing

 

Thank you, Eloise

v-yalanwu-msft
Community Support
Community Support

Hi , @elois33 ;

You could try create a measure rather than filter this measure.

CouponLEN = 
VAR MINValue= MIN('LENGTH'[Value]) 
VAR MAXValue= MAX('LENGTH'[Value]) 
VAR CurrentValue=SUM('Table'[lenght] )
RETURN CALCULATE(SUM('Table'[lenght]),FILTER('Table',[lenght]<=MAX('LENGTH'[Value])&&[lenght]>=MIN('LENGTH'[Value])))

 the final show:

vyalanwumsft_0-1669097951332.png

If the above one can't help you get the desired result, Can you share a simple file to remove sensitive information? I can't reproduce your data and tests.
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

thank you for the solution provided and I m very sory the the delayed answer. Well my "lenght" and "weight" capacity is already a measure calculated from 2 columns (total capacity minus used capacity) so a measure which includes another measure on it, it doesnt work for that. 😕 Do you know maybe another way?  thanks

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Feb2025 NL Carousel

Fabric Community Update - February 2025

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