Hi, Is the attached what you are looking for?
I imagine there are easier solutions to this but what i did was...
Duplicated the data source.
Made a field called "Link" in each source that was just a constant value and used that as the link to blend the 2 sources.
Made a parameter to choose the advertiser.
Made a calculated field in the duplicated data source that only returned the ratings for the advertiser chosen in the parameter.(case [Brand] when [Parameter 1] then [Rating] else null end)
Dragged that calculated field into the marks card.
Added a reference line using that field.
This way the filters you choose for your bar chart wont apply to the average coming from the duplicated data source.
Hopefully this helps.
Book4.twbx 10.8 KB
Thanks a Lot. It worked like a charm.