How to remove dotted lines as data for empty fields when exported in excel or others

Hello Developpers, Since I did add all fields in list format, I am now receiving dotted lines as data for empty fields when I do export in Excel or PowerBI which lead my measures into errors. I need very a help on how to remove the dotted lines as data for empty fields. Thanks