Forum Discussion
stusam
Mar 12, 2024Copper Contributor
Slicer for line chart
Hi. Is it possible to add a slicer to the below chart to hide/reveal each of the individual categories? Thank you.
SandeepMarwal
Mar 12, 2024Brass Contributor
stusam check this out, if this fulfills your requirement.
Raw data :
first data is unpivoted:
than pivot table is created:
than pivot chart is created and slicer is added in pivot chart
Limitation : Only one field can be shown at a time.