Forum Discussion
Helper IField parameters conidtionnal
Hi guys,
I have an issue I am not sure it is possible to solve: I created a list with field parameters that I would like to filter based on a simple condition.
Is it possible to dynamically filter a list?
Somehting like:
Filter_List = IF(SELECTEDVALUE(Table)="xxxx", -- show a selection of elements from a list )
Thanks a lot for your answers.
See if you can adapt the solution below. The concept is to create a table ParameterFilter that has a relationship with the system-generated parameter table. Then create a slicer using ParameterFilter, and it will display only the relevant items in the list.
6 Replies
- DataInsights
Super User
See if you can adapt the solution below. The concept is to create a table ParameterFilter that has a relationship with the system-generated parameter table. Then create a slicer using ParameterFilter, and it will display only the relevant items in the list.
id9213Thanks a lot DataInsights , that is working!
I would only have one additional demand to make it perfect: when I change the "filtering" list, the choice of the second one still remain. That means that as long as I do not select something, you will have an item selected that should not be available.Do you know if there is an option to "reset" a list to avoid this issue?
Thanks a lot for your help.
- DataInsights