This content has been marked as final.
Show 1 reply
-
1. Re: Average Line for filter table
Vanessa HarmonMay 18, 2017 4:53 PM (in response to Alex Martino)
I think you should be able to create a calculated field to compute the Sales average and uses a Level of Detail function to exclude category, and then build a reference line using that calculated field.
For example, using superstore I created the calculated field:
{exclude [Sub-Category] : avg([Sales])}
Placed that field on detail, and used that to create a reference line over my bar chart.