Forum Discussion
Using Field parameter slicer to select which column should be used for filtering table visual
In my example I have one column containing all the available applications. The additional four columns are showing what applications that are either "Standard", "Optional" or "N/A" for the different user groups.
In my report (bottom half of the example) I would like to have a slicer for selecting user group (column 2-5) and to use the values in the selected column to filter the two table visuals showing applications that are "Standard" and "Optional" respectively.
I assume this could be done most elegantly using Field Parameters, but I have not found out how I can dynamically change the filtering based on selection of user group column. The only thing i want to show is the aplication column values where the corresponding value in the selected column is "Standard" or "Optional".
Hi JarleR
First, in power query, hold down the CTRL key to select these four columns, then click unpivot.Then create two tables, drag the corresponding fields into the table.
Then set the corresponding filter criteria for two tables.
Result:
Best Regards,
Jayleny
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
Hi JarleR
First, in power query, hold down the CTRL key to select these four columns, then click unpivot.Then create two tables, drag the corresponding fields into the table.
Then set the corresponding filter criteria for two tables.
Result:
Best Regards,
Jayleny
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you! That worked for my production data as well. Do you think it is at all possible to achieve the same using Field Parameters as well - without changing my data model (which is also used for a lot of other things)?
