Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.

Reply
ScORE
Helper I
Helper I

Display zero instead of blank in matrix

  1. Hello, any help is greatly appreciated.  I have imported a folder and pulled in tables from all of the files in the folders.  The tables are identical in table name, column name and type.  When I imported them there weren't any errors, however I noticed that for some of my rows of data the query shows 0 (zero) versus the actual number value that is in some of the tables.  I have looked at paramentere, data types, decimals and rounding, but nothing pulls in the number instead of zero.  I need help fixing this issue.  Any recommendations or solutions are welcome!  

 

Thanks in advance!

SC

1 REPLY 1
v-ljerr-msft
Microsoft Employee
Microsoft Employee

Hi @ScORE,

 

Could you post some screenshots and share some sample files which can help us to reproduce the issue, so that we can help further investigate on it?

 

To share the files, you can upload them to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading. Smiley Happy

 

Regards

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.