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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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
Employee
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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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