Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
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
These numeric slicers are:
Once the users insert values to each slicer, I want only to show equal or greater values on the matrix table that follows.
For weight values:
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:
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 🙂,
@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
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:
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
126 | |
78 | |
76 | |
59 | |
51 |
User | Count |
---|---|
164 | |
86 | |
68 | |
68 | |
58 |