Forum Discussion
How to show and hide data using a slicer or parameter slicer?
Hi, can anyone please help with a simple solution to show and hide data on a line chart? I will have alot of persons on containing data as per this example:
I need a slicer to hide and show each person (or multiple persons) line on a line chart. What is the easiest solution to do this?
Thank you in advance.
Daniel
Unpivot the table- either at the source, or in the Query Editor:
1. Right click the table, then Edit query
2. Select your date column (or any other column which is not the persons column)
3. Follow this example
Now you have a dimension (Persons) which you can use as a slicers.
If the table would have more people, they would get unpivoted as well.
Select thisVictory!
2 Replies
- rbriga
Impactful Individual
Unpivot the table- either at the source, or in the Query Editor:
1. Right click the table, then Edit query
2. Select your date column (or any other column which is not the persons column)
3. Follow this example
Now you have a dimension (Persons) which you can use as a slicers.
If the table would have more people, they would get unpivoted as well.
Select thisVictory!
