Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there,
I'm trying to build a page that has two similar charts, and two sets of identical filter panes. How can i set this up, if i want a a filter pane to only influence one the charts?
Thanks.
Hi,
I have a KPI chart and 4 filters and I have written an expression like below:
The KPI doesn't change even when I select the filters
Sum({<[Reporting Area] ={*},
[Reporting Group 3] = {*},
//[Reporting Group 2] = {*},
[Reporting Group 1] = {*},
[Reporting Group] = {*},
File_Type = {"Actual 2016"}>}Value)/1000000
So in one of the sheet where you don't want the metrics to change based upon the filter you filter name and * like above... Hope this helps.
Thanks
Hi,
I'm not sure that helps. What i'm trying to achieve is to have a filter only change one of the charts so that i can compare sets of values, something along these lines:
In this example i'm using the calculation condition, but if both conditions are met then both charts are affected by the selections above.