Forum Discussion
Data
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.
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.
3 Replies
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] + 0https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-show-items-no-data
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.
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.
