Hi
I was wondering if anyone could help regarding seleciton chart data. To put into context, I have 2 sets of cumulative performance data over time (3 years) for Portfolio1 and Benchmark1. On the report page are various charts showing the composition of Portfolio1.
On a line and bar chart I have the cumulative and daily returns for Portfolio1. What I would like to do for the this chart is to select which data sets are shown. I.e. Showing Portfolio1 with it's selection (checked), then adding the benchmark perfomance data on with a selection (check) box. When I add the various points to a slicer it adds each specific data point (numerical) as opposed to allowing me to select Portfolio1 or Benchmark1 data.
Is there anyway of doing this other than putting various charts overlated and using buttons and bookmarks for each combination?
Thank you in advance!!
