topic Re: How to hide measure if its a null or 0 value in a chart? in App Development

How to hide measure if its a null or 0 value in a chart?

arielg — Fri, 24 Mar 2023 22:58:11 GMT

Hi! I am trying to create filtered views in a table, but can't figure out how to hide rows with measure having 0 or null value. I've tried disabling "Include 0 values" from data handling, and setting the output of this expression to display NUM values, but still not working. Expression below is calculating if date in Log for a record is within last day days.

=IF((today(2)-daystart(max({<[Session Count] = {1}>} LogTimeStamp)))<90,NUM(today(2)-daystart(max({<[Session Count] = {1}>} LogTimeStamp))),NUM(0))

Re: How to hide measure if its a null or 0 value in a chart?

BrunPierre — Sun, 26 Mar 2023 06:36:20 GMT

Hi, how about changing NUM(0) to NULL() for the else parameter?

Re: How to hide measure if its a null or 0 value in a chart?

luciancotea — Mon, 27 Mar 2023 08:54:40 GMT

If the row doesn't hide, it means that you have another measure with a non-zero value on that row.