Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
mrmatt
Contributor III
Contributor III

Filter measure data

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).

Labels (1)
2 Replies
Arthur_Fong
Partner - Specialist III
Partner - Specialist III

In chart properties > Add-ons >uncheck "Include zero values":

MC.PNG

Lisa_P
Employee
Employee

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