Forum Discussion

Julier's avatar
Julier
Helper III
9 months ago
Solved

column headers as a slicer

Hello, I have my data in power query as below which i have a chart and a table  visual working from this,  i want to be able to slice the table and the chart with a slicer using the column headers, i...
  • PhilipTreacy's avatar
    9 months ago

    Julier 

     

    Download this example PBIX file 

     

    So what you are trying to do is only show the columns of data selected in the slicer?

     

    You can use a Field Parameter for this.

     

    From the Modelling menu -> New Parameter -> Fields and add the Fields (columns)

     

     

    make sure the check box 'Add slicer to this page' is checked and click Create

     

    Create a table and add the parameter you just created, use the slicer to display the columns you want

     

     

     

    Regards

     

    Phil