Forum Discussion
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...
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
Julier Please provide us with a sample file so that I can make some changes and send it over via this thread.
You can upload the sample file to a dropbox and share the link over here.
Thanks,
Jai
Hi, sorry, I dont have drop box