Zero data visualizations

Philip · ‎10-11-2016

Hi,

Is there a way to prevent a visualization appearing in a dashboard if the data driving it is 0 (zero),

but present the visualization if the data driving it is 1+ (more than 0)?

Thanks in advance Philip

ankitpatira · ‎10-11-2016

@Philip You won't be able to completely hide the visual but somewhat hide it (atleast data points) like bars of bar chart until value is greater than 0. To do that create a measure as belwo and then use that measure as Values for the visual. You should also vote for this idea.

Measure = IF ( SUM(TABLENAME[valuesColumnName]) > 0, SUM(TABLENAME[valuesColumnName]), 0).