Forum Discussion

JarleR's avatar
JarleR
Frequent Visitor
1 year ago
Solved

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 d...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    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.

     

Anonymous's avatar
Anonymous
Not applicable
1 year ago

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.

 

  • JarleR's avatar
    JarleR
    Frequent Visitor
    1 year ago

    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)?