Hi @Santi98,
You can achieve this by using ‘specific values’ on your control.
Once you’ve created your multi-select parameter for Services, create a control for it as well. Instead of linking it to the dataset, add in your services to the ‘define specific values’ section. They will need to be case sensitive so make sure you match any capital letters used (one service per line):
Next, add a filter to your visual(s) that equals your parameter:
One additional note, consider adding default values to your parameter so that you can remove the ‘select all’ option. This will populate all service options still, even if they are no longer an option in the dropdown.
Let me know if you have any additional questions!
Hola @Brett,
Lo intente de esa manera
Pero el tema es que me deshabilita la opción de que se actualice la información conforme al cambio de otros filtros, ya no me aparece la opción de solo valores relevantes
Hi @Santi98,
Correct because you are already specifying the values being returned through using ‘specific values’.
So are you saying that for your case, the ‘Services’ control is linked to only show relevant values based on other control?
Hola @Brett correcto, el reporte tiene varios filtros y el objetivo es que también se muevan conforme al filtrado de otro filtro.
Hi @Santi98,
Understood. So in this case, you’ll have to create a calculated field on your dataset layer to limit the response from returning that value. Something like:
ifelse(Servicio<> 'Valores Banco', Servicio, NULL)
Then you can do a parameter control where you can exclude nulls:
Hi @Santi98,
It’s been awhile since we last heard from you, did you have any additional questions regarding your initial post?
If we do not hear back within the next 3 business days, I’ll go ahead and close out this topic.
Thank you!
