Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is it possible to filter measure data in a chart? If so how. My data has Os and Nulls which I want to exclude (just from this chart and not the whole data set).
In chart properties > Add-ons >uncheck "Include zero values":
One way to do this is to use Set Analysis.
If you are summing sales as an example, Sum(sales)
you could write the expression as Sum({<sales={">0"}>}sales)
so it will only sum the sales where the values are greater than zero