Slicer for line chart

Copper Contributor

Hi.

 

Is it possible to add a slicer to the below chart to hide/reveal each of the individual categories?

 

stusam_0-1710232390976.png

 

Thank you.

 

2 Replies

@stusam check this out, if this fulfills your requirement.

Raw data :

SandeepMarwal_0-1710244292120.png

 

first data is unpivoted:

SandeepMarwal_1-1710244328677.png

than pivot table is created:

SandeepMarwal_2-1710244358182.png

than pivot chart is created and slicer is added in pivot chart

SandeepMarwal_3-1710244407488.png

 

Limitation : Only one field can be shown at a time.