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/
3 Replies
Anonymous how would you like to see it? You need to share your sample data and what measures you have created and how you are visualizing it. There can be many ways to show/hide null/blank values and without looking at the full picture it is very hard to solve it.
Read this post to get your answer quickly.
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490You 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.
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/
