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

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. 

BhaveshPatel's avatar
BhaveshPatel
Super User
9 years ago

Yes. You can do that as well. You need to create Index Column in your Fact Table in the Query Editor.

To do so, Go to the Edit Queries, Go to " Add Column" Tab, Select "Add Index Coulmn", Select From 1.

Load your Query Now. 

 

Prepare the Graph as shown in the screenshot and You can view the 3 different lines for 3 different Samples.

 

3 lines for 3 samples.