Slicer showing first Blank value , how to remove it?

[Anonymous]

hi all,

created Countries table from my data table from within Transofrm data,

selected Country column, created lookup table with Enter data, pasted all selected rows and Removed Duplicates ... but when created a Slicer it is showing a (Blank) value at starting point (left most in Slicer), how to get rid off this value which creating problem? when checking it in Data there is No Blank value.

screenshot:

regards

EDIT: when created Table visual for the same, it is not showing any Blank value. (updated screenshot above)

[V-pazhen-msft]

@Anonymous 

Glad you fixed the issue.

Normally there will be a blank option in a slicer. To remove it, you may just replace blank with null in the power query editor then filter to is not blank. 

For new questions, please create another new post. 

Best Regards

Paul Zheng _ Community Support Team

[Anonymous · Accepted solution]

its done, don't know what was the problem, may be some misbehaviour.

created lookup table first time, there was 7 missing entries, deleted then created 2nd time with same Data Table then there was 3 missings and now 3rd time created with same Data Table and it has all countries ... at last. thank god 🙂

please close this thread as i can't mark it as Accepted as Solution.

regards

[Anonymous]

hi all,

@amitchandak @Fowmy @Ashish_Mathur @v-stephen-msft 

created and checked again 2 times with 2 different machines, the same findings. 

when creating Lookup Table from my actual Data Table column Country without scrolling it was leaving some rows but after scrolling upto the last row it is selecting all rows and no data left, all country column data selects and created Lookup Table.

Why this occurs when first we have loaded Excel file completely? is there any Memory problem? or any option/settings we have to set? My Windows 10 VM has 8 GB RAM, 100 GB HDD ( created using VMWare Workstation 16) is there any problem with VM or OS or any .Net Framework or Win 10 patch I have to install? Total no. of rows are 1162.  please help.

regards