Forum Discussion

Julier's avatar
Julier
Icon for Helper III rankHelper III
10 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
    10 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