Forum Discussion

mrrob's avatar
mrrob
Frequent Visitor
9 years ago
Solved

Using slicer to filter columns

Hi! Is it possible to filter columns using one slicer? I would like to add few table columns to 'values' (axis x doesn't change it's a date) and pick on slicer which value should be displayed.   T...
Need Help
  • BhaveshPatel's avatar
    BhaveshPatel
    9 years ago

    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's avatar
BhaveshPatel
Super User
9 years ago

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

mrrob's avatar
mrrob
Frequent Visitor
9 years ago

Thanks for solution. 

One additional question. Can I change this slicer to multi select slicer? Now when I check 2 boxes the slicer summarize 2 samples column values to one line.