Data

[rima_ch]

Hello everyone,

I am having problem displaying data, I have these 2 tables 

in a visual I need to display column1 and sum(ss) of table2 and column3 of table, but this is what i get 

this row is  not appearing in the visual 

 because it does not exist in the Table 

so why the A8 is not displaying? What should I do to make it apear I want to have something like this 

Thank you in advance.

[Anonymous · Accepted solution]

Hi @rima_ch ,

Please try below steps:

1. my test table

Table:

Table 2:

Model:

2. add a table visual and add the fields

Please refer attached .pbix file.

Best regards,
Community Support Team_ Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[danextian]

Hi @rima_ch , 

By default, those with blank measure values will not appear in the visual. You can either make the measure show 0  when it returns blank using a similar formula below or you can enable Show items with no data.

Measure2 = 
[Measure1] + 0 

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-show-items-no-data 

 

[rima_ch]

Thank you for your answer, but here what i got, why is this happening 

and show data I've already try it it's not a solution for my case because I've got something similar to that.