How to show data in a visualisation from two tables where there isnt always a relationship

[HelC]

Apologies in advance as I am not only novice in PBI but also to this forum.  I have a main table that shows training for all staff in our Learning Mgmt System together with a status that shows the progress starting with assigned, then enroled through to completed.  In this table is the price as shown in a course catalogue so what we would expect to be charged for the training.  On a monthly basis we are charged for training either completed or cancelled within a charge period this data sits in another table.  At the moment I have a relationship set up of 1 to many but this might be the issue.  I have created a measure against the cost in the charge table so if there were two lines - one for a late cancellation but then a second when the training was completed it would show the total charge which in this instance would be twice the catalogue cost.  When I try to add the measure into the visualisation any line that doesnt have a record in the charge table is then removed from the visualisation.   What I want to see is the line stay in the visualtion but with the charge column blank if there is not charge yet so we would know that the cost of the training has not been charged yet.    Thanks in advance

[audreygerred · Accepted solution]

Hi! In the build pane of your visual, right click on the item that you want to stay (this should be coming from the dimension table, i.e. the table that is the 1 side of your 1:M) even if there is no data related to it from the fact table (M side of your 1:M). You should see an option that says 'Show items with no data' - click that 🙂 

[HelC]

Oh my - what a simple solution when you know it's there,  Thank you its made my day !