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.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
81 | |
70 | |
62 |
User | Count |
---|---|
148 | |
116 | |
104 | |
90 | |
65 |