Forum Discussion
To change what if parameter value based on slicer
Community SupportHi Anonymous
I can create a parameter table which shows different range based on different category.
Parameter =
UNION (
ADDCOLUMNS ( GENERATESERIES ( 500, 9000, 100 ), "category", "B" ),
ADDCOLUMNS ( GENERATESERIES ( 2000, 20000, 1000 ), "category", "A" )
)
measure
selectedvalue =
SWITCH (
SELECTEDVALUE ( Parameter[category] ),
"A", SELECTEDVALUE ( 'Parameter'[Parameter], 8000 ),
"B", SELECTEDVALUE ( 'Parameter'[Parameter], 4000 )
)
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.
Hi v-juanli-msft,
Thank you for your reply. I tried replicating the solution but I guess it's not fully working. Initially, it is working fine as if I select A the value is changing to 4000 and if I select B value changes to 8000. But the slider parameter is not working correctly. I want that if B is selected the parameter slider should only have the range of category B(500-9000) and if I select A the parameter slide should only have the range of A(2000-20000). Currently, it's showing all the range(A+B) and because of this, we are not able to slice it correctly.
Initially-
Sample issue(not able to see A as this value is not in A, ideally based on the category selection the parameter slider range should change)-
- v-juanli-msft
Hi Anonymous
do you edit interactions for visuals?
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.