Forum Discussion
NULL value in visuals
Hi, can I somehow not show NULL values in visuals? I got the following problem: In my line chart the lines always go down to zero when there is a NULL value which is really confusing. ...
Anonymous
It seems the measure returns zero instead of blank. You may take a look at the articles below.
- https://www.sqlbi.com/articles/how-to-handle-blank-in-dax-measures/
- https://www.sqlbi.com/articles/blank-handling-in-dax/
You can filter using the visual level filter. In visual level filter go remove blank. But if it time series or view by time. It might not be good idea.