Number not showing up in table

[zudar]

Hi all,

I'm having an issue with a simple table in a report where an integer value is not showing for (let's say) 'Products' that have no Category in a related dimension table.

I had this issue with multiple columns and found out that if I reorganize the order of columns so that columns from a table are all next to eachother, they would show up. 'Show items with no data' has been ticked all along.

So I went from:

A[1] (Product ID)	B[1] (Category)	A[2] (string)	A[3] (date)	A[4] (integer)
Value shown	No Value found!	No Value shown!	No Value shown!	No Value shown!

To:

A[1] (Product ID)	A[2] (string)	A[3] (date)	A[4] (integer)	B[1] (Category)
Value shown	Value shown	Value shown	No Value shown!	No Value found!

I hope this makes sense!

What do I need to do to show A[4]?

I don't want to change it to text-type, that just feels stupid!

Thank you!

[PhilBorer]

Similar Problem perhaps - number now showing up in visualization table, where there is both Text and Number values.

Number not showing up in table:

Here, i'm expecting 121328 to appear in the second column (hoping to get rid of third column). This is in the table visualization.

In the queried data:

Again, where the main asset tag is null, i want to see the Alternate ID/tag, and this could be number or text. My problem is that the Asset tag from column 1[Asset Tag] is not showing up in the visualization above (like the data point 121328 example above). 

The query formula shows:

How do i make 121328 show up in the table?

[amitchandak]

@zudar ,The information you have provided is not making the problem clear to me. Can you please explain with an example.
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Appreciate your Kudos.

[zudar]

@amitchandak& @Greg_Deckler 

I'm actually unable to recreate the issue using sample data.. 

The PBIX with the actual issue is too data sensitive for me to share with you.

What happens in my case is that even in 'Result B' table below (compared to 'Result A'), the price remains empty:

I will try to do some more investigating and return with more info.. 😫

[zudar · Accepted solution]

I was able to find the issue in my actual file: I had the 'Sum' setting on the (equivalent of the) price field instead of 'Don't Summarize'!

[Greg_Deckler]

@zudar - Hard to tell what is going on. Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.