Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have a matrix that has multiple values in the values section.
I have a parameter slider to filter the data, so users can see records where the value is less than whatever they have selected on the slider.
This works fine if i have just one measure in the values, and that measure filters based on the slider.
if i add another measure, then the records dont disappear if i adjust the slider.
All that disappears is the value in the measure being filtered.
My question is: if i have multiple measures on the matrix, how can i ensure that rows are added and removed as the slider is adjusted?
The below screenshots may explain the situation better.
This link points to a pbix that illustrates the issue with sample data.
https://1drv.ms/u/s!AgldA0VQfPV9hNQ2ACoMMQeTkZo6SQ
e.g. in the below image, when the matrix has just one measure, the rows are added and removed depending on if the measure is less than the slider value.
In the 2nd image, i have added an additional measure. now if i move the slider, no rows are removed. The value of the original measure just turns blank if its less than the slider value.
It is by design for another measure under column(1,2,3,4) is not blank.
It will remove when two measures are both blank.
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.