Forum Discussion

dankello's avatar
dankello
Frequent Visitor
3 years ago
Solved

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...
Need Help
Show and Tell
  • rbriga's avatar
    rbriga
    3 years ago

    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!

rbriga's avatar
rbriga
Icon for Impactful Individual rankImpactful Individual
3 years ago

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!