title: How to add target line to a pivot-chart?
body: <p>I have a resource allocation report that automatically generates each week based on a bunch of monthly data. The data is summarized in a PivotChart with slicers for different column values (Name, Role, Project, etc). The chart shows the units allocated for each role, for each month for the next 13 months: 
  <a href="https://i.stack.imgur.com/a6DCx.png" rel="nofollow noreferrer">Resource Allocation PivotChart</a></p>
  
  <p>Basically, I want to add a target line to this chart. I've tried a couple different things. </p>
  
  <p>With other projects, I've succeeded in adding a target to PivotTable data by adding the target value in a column next to the PivotTable, but that won't work with this report because that method forces me to use a regular chart instead of a PivotChart so I can't have the slicers (which I need), and the PivotTable changes shape a lot so it would overwrite the data as different slicer options are selected and as new values are added to the data each week.</p>
  
  <p>The closest I've gotten to adding the target into the chart is by actually creating a new line item where the Role is "Target" and the value for each month is the target value: <a href="https://i.stack.imgur.com/mYIXe.png" rel="nofollow noreferrer">Target line item</a>. I can even change the data series type to look like a target line: <a href="https://i.stack.imgur.com/zKLs2.png" rel="nofollow noreferrer">PivotChart with target line</a>. The only issue is that "Target" now shows up in <a href="https://i.stack.imgur.com/EBVNQ.png" rel="nofollow noreferrer">the role slicer</a>.</p>
  
  <p>Is there any way to hide "Target" from the Role slicer when it HAS data? Or is there some other way to add a target line to this PivotChart? </p>