Forum Discussion
Using slicer to filter columns
Please see the attached screenshots for the solution.Select the Date column and Create a Query step - unpivot other columnsCreate a samples tableCreate a connection with Samples TablePrepare a line chart with all the fields coming from the first tableSlicer should be coming from the Samples Table
BhaveshPatel I know but it isn't what I want to do.
I would like to do something like that (line chart):
x axis: date (column from table 1)
y axis: sample1, sample2, sample3 (columns from table 1)
and simple slicer to pick which of sample should be displayed on the line chart at the moment.
It isn't row filtering.
Thank you for your clarification. I don't think so you can put on columns on the slicer.
Any ideas how can I do it another way?
I am trying a solution for you. Once done, will definitely let you know.