The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the August 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
82 | |
63 | |
53 | |
51 |
User | Count |
---|---|
127 | |
118 | |
81 | |
65 | |
64 |