Forum Discussion
index
version 2.81.5831.1181 64-bit (May 2020)
Hello,
I have quite a large volume of data (10841 rows) but still not that big.
Issue:
Once I have add the index column and sort the column by index some of the indexes are not displayed
(but in Power Query Editor I can see the index).
Can anybody help with this ?
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.
3 Replies
You shouldn't need to sort an index column after you've added it. Do you have any Filter steps after you add the index, which would explain the missing values?
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
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.
