Forum Discussion
mrrob
9 years agoFrequent Visitor
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...
- 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
Anonymous
9 years agoNot applicable
Have you tried to use the heirarchyslicer in https://app.powerbi.com/visuals/ ?
mrrob
9 years agoFrequent Visitor
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.