unable to show full data because of join from one table to another

[lawadaa]

i have 3 tables for each of the following

1- transactions table

2- target table

3- categories table

in transactions table, i need to show each agent achievement of target. target is taken from target table. 

the problem i have is, if an agent doesnt have achievement in 1 category, category will not be shown at all. although this category has a target and in this case, it should show me achievement of zero.

this is how my data model looks like 

my join key between target and transactions table is based on : category/type/Branch/month

my join key between category and transactions tables is based on: category/type

result im getting

expected result should show target for all categories even with zero achievement 

category	type	target	achievement
Gross Add/Migration/MNP	Data	51.46705143	10
Gross Add/Migration/MNP	Voice	156.6556028	0
Renewal/Upgrade	Data	30.95296584	0
Renewal/Upgrade	Voice	152.5606116	12
Zeed		79.50665901	15

any idea how to resolve

thanks in advance

[PijushRoy]

Hi @lawadaa 

Looks there are some relationship issue
Please keep few sample data, remove the sensitive data then share the pbix file
All production data are not needed, only sample format data should be ok
Please share pbix file via google drive and allow all access and share the link. Remove the file from google drive after solution of your ticket.

[PijushRoy]

Hi @lawadaa 

Can you applied this step for all data points, please confirm

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

If solve your question, please hit the 👍 and mark as SOLUTION

[lawadaa]

it did not solve my problem

i want to keep the categories with no achievemenet. still those categories are not shown