Forum

Metric Overtime Lin...
 
Notifications
Clear all

Metric Overtime Line Graph: Slicer for Choosing which variable is presented

2 Posts
2 Users
0 Reactions
58 Views
(@jhirst22)
Posts: 1
New Member
Topic starter
 

Hi All, 

I'm currently working on a Dashboard where I want to create a line graph that shows an individual's batting statistics over time. Rather than creating 6 different figures, I would like to create one figure that communicates with a slicer that allows the user to choose which statistic(s) they would like to see.

I am making use of the Data Model Manager, and therefore taking advantage of connecting tables in pivot charts. Currently I do not have a way of connecting the names of the statistics to actual database of values, and therefore can't easily add a slicer to manipulate the figure. 

Any help/guidance is greatly appreciated!

 
Posted : 30/05/2020 4:22 pm
(@mynda)
Posts: 4761
Member Admin
 

Hi Jacob,

Welcome to our forum! Have you seen this tutorial on changing PivotTable aggregation methods using Excel Slicers?

Hopefully that points you in the right direction, but let us know if you get stuck.

Mynda

 
Posted : 31/05/2020 5:18 am
Share: