Forum Discussion
Help with table relation
So I have two tables Input and Output which has ID and Master ID as foreign key relating to each other.
My chart is showing output data while a table below is showing input data.
If I add output date (results) to the input data then the table only shows info of output while it should also include input table.
Input table:
| ID | Name | Age |
| 1 | Arthur Morgan | 22 |
| 2 | Dutch Van der linde | 32 |
| 3 | Hosea Matthews | 45 |
Output Table:
| Master ID | Answer 1 | Answer2 |
| 1 | Yes | Yes |
| 2 | No | No |
Problem is
When I show the answer 1 on my column chart it shows 2 counts,
Expected output on Table:
| Name | Age | Answer1 |
| Arthur Morgan | 22 | Yes |
| Dutch Van der linde | 32 | No |
| Hosea Matthews | 45 |
Problem is when I add answer 1 from Output Table, it only shows name who has only answered the questions. I want all input appear on the table even if answered or not.
ID and master ID are already connected on table relations.
Thank you for help
6 Replies
it does work, problem is I think the column chart is filtering the table since column chart only contains answered questions. It does not show Hosea.
Hi Kalachuchi,
If you select Id from your Input table as axis and count Answer1 as values in a Column chart, make sure you expand the arrow in the Id field and select "Show items with no data", and you get this:
Hope it helps.
Regards,
Fernando
Is that what you're looking for?
https://1drv.ms/u/s!AnIEh6WhI4JogrAAnyDVVkj51F1Xdg?e=v77bfY
I've created a sample PBIX to show you how to achieve this. essentially, I've just merged the two, together then replaced "null" with "No answer"
Did not know this merge function lol. It worked, thank you so much!
