Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have several charts which use
If([Date.Size]='4mm',Avg([Actual Cost £]))
or similar to get the data. How can I make the chart visual and data stay regardless of the filters selected.
Thank you all for trying to help but everything that I have tried you can still filter the chart
nothing is making it static.
you need to make sure that any filter you want ignored should be in the set analysis in the form of
Field=
or just
Field
this means ignore the filter. obviously, if you have more than one field to ignore, they should be separated by a comma
adding {1} should ignore all filters as well. so if any filter is still being recognized, something else is affecting it. look at all the measures.
one thing you can do is create a new chart and just add a single measure and see if the problem persists. and start building on it until your problem manifests itself.
@RichardLee
Try to start with a chart with only one dimension and your AVG formula, and see if it works.
If works, try to add other Dim/measure one-at-a-time to see which Dim/Measure broken it.
Since you did not post enough information here, like a whole chart screenshot with all data dimensions & measures, it is very hard to tell where is the root cause.
1) do you have a calculated dimension?
2) is the chart assigned to an alternate state?
No the Dimension is not Calculated and it doesn't have an Alternate sate