Here is my PivotChart currently:


The solid line show the average scale factor in each verified depth range, and the dashed lines shows the mean value across all verified depths. I would now like to show the standard deviation across all verified depths, ideally as an area surrounding the global mean line (although I guess error bars would do). I have a measure in my data model: StdRadialScaleFactor70000:=calculate(STDEV.P([ScaleFactor_R_70000]),all(Table3[DepthGroupName])), but I can't figure out how to use it.

Can anyone help me with this please?

Also 70000, 80000,... are applied fields, the data for each is a separate column in the data set. Can I add a slicer to only show one applied field at a time?

Many thanks and Happy New Year!