Table Viz not displaying zero (problem is not "show items with no data")

[rdamillrda]

I have a table visualization on the canvas set up that currently looks like this:

[TABLE="width: 500"]
<tbody>[TR]
[TD]Company[/TD]
[TD]Place[/TD]
[TD]Incident Count[/TD]
[/TR]
[TR]
[TD](Blank)
[/TD]
[TD](Blank)[/TD]
[TD](Blank)[/TD]
[/TR]
[TR]
[TD](Blank)[/TD]
[TD](Blank)[/TD]
[TD](Blank)[/TD]
[/TR]
[TR]
[TD]Company A[/TD]
[TD]Place 1[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]Company A[/TD]
[TD]Place 2[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]Company A[/TD]
[TD]Place 3[/TD]
[TD](Blank)[/TD]
[/TR]
[TR]
[TD]Company B[/TD]
[TD]Place 4[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Company C[/TD]
[TD]Place 5[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]Company D[/TD]
[TD]Place 6[/TD]
[TD](Blank)[/TD]
[/TR]
</tbody>[/TABLE]

The table is not displaying zeros. I do have "Show items with no data" checked for both Company and Place. I think there are 2 problems: 1st) For Company A/Place 3 and Company D/Place 6 the places do not appear in the source data table. The company and place are pulled from a separate data table. For some reason, the incident count is not showing zero. The 2nd problem has to do with the first two rows. The first blank row is a sum of all rows below it. It should read All Companies, All Places, and Incident Count = 5. The second row is a sum of Company A for Places 1, 2, and 3. It should read Company A Sum, All Places, and Incident Count = 2. No matter what I do I cannot get it to show. Any suggestions on this? Been working on it for far too long. Thanks.

 

[Fazza]

Hello, Please can you explain what you've done? And the Excel version.
If there is input data, please show & explain the input data & how it relates to the result; and if it is different, the expected result.
Thanks

 

[Fazza]

Hello, again. I've only just now noticed your question is in the "Power BI" section. Power BI is not my field, and so why I didn't understand about things like "table visualization on the canvas set up" - which led to my earlier comments.

I likely can not help with a Power BI solution - but also likely can help with an alternative approach. So I'll keep an eye on the thread & chime in again if I think it will help.

regards