Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
I'm using combo chart with multiple expressions, few expressions has zero values.
Any workaround to exclude Zero values ?
You should be able to hide zero values by going to add-ons, data handling, and unchecking the box to include zero values
What you circled aren't zero values... there's a 3 in there. And presumably the other groups also have at least one value for a dimension member (month), which is why they're showing up?
I did check this but nothing change
Product wise I have written measure, but few measures doesn't have values because showing the Zero.
But User doesn't wants see zero values.
I'm sorry, it's not helpful to me if you just say the exact same thing you did before without referring to what I wrote. These are presumably not zero value measures.
Try this
If(Sum([YourMeasure]) > 0, Sum([YourMeasure]))
Or
Sum({<YourField={"<>0"}>} YourMeasure)