Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 paulwalker
		
			paulwalker
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi Experts,
I'm using combo chart with multiple expressions, few expressions has zero values.
Any workaround to exclude Zero values ?
 JR4
		
			JR4
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		You should be able to hide zero values by going to add-ons, data handling, and unchecking the box to include zero values
 
					
				
		
 Or
		
			Or
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		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?
 paulwalker
		
			paulwalker
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		I did check this but nothing change
 paulwalker
		
			paulwalker
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		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.
 
					
				
		
 Or
		
			Or
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		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.
 Chanty4u
		
			Chanty4u
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Try this
If(Sum([YourMeasure]) > 0, Sum([YourMeasure]))
Or
Sum({<YourField={"<>0"}>} YourMeasure)
