Forum Discussion
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.
Thanks in advance.
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
11 Replies
Yes. It is a native behaviour of PowerBI. For Example, If the column A in Table is filtered, all the associated records in other columns will also be filtered.
Records in the year 2009Records in the year 2011
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.
Have you tried to use the heirarchyslicer in https://app.powerbi.com/visuals/ ?
Anonymous I don't want to build hierarchy between them. Unfortunately, I can't use that slicer without building hierarchy. It isn't result that I expect.
