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.
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
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.
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.