Forum Discussion
index
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-show-items-no-data
if you are adding column with values which can be summarized --> to show items with no data you need to firstly turn off the Sum function in Values part --> then tick the option Show items with no data --> and then when you need to tick Sum function again.
I have found the problem, as power BI is evaluating quality of each column, the column which have some null values are automaticaly not showed in the visualization.
Is this some new feature ?
I do not remmember that the PowerBI was filtering the null out of visuals by default.
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-show-items-no-data
if you are adding column with values which can be summarized --> to show items with no data you need to firstly turn off the Sum function in Values part --> then tick the option Show items with no data --> and then when you need to tick Sum function again.