Target to show regardless of Connection

[Anonymous]

Hi,

Please help.

I am new to Power BI & busy building my first dashboard.

I have a Dimension table with multiple fact tables. 1 of my fact tables is a target file which has multiple rows with targets by customer, segment & month. I have done a combined column with these fields & done the same in the dimension table to create a 1 to many relationship.

However when I pull in the target on the dashboard only those that have matches show the target. How do I go about reflecting the full target even if there is no match in the dimension table & allow for slicing in customer, segment or month?

[v-zhenbw-msft]

Hi @Anonymous ,

How about the result after you follow the suggestions mentioned in my original post?

Could you please provide more details or expected result about it If it doesn't meet your requirement?

If you've fixed the issue on your own please kindly share your solution. If the above posts help, please kindly mark it as a solution to help others find it more quickly.

Best regards,

Community Support Team _ zhenbw

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , see if you have a target for one customer, not for others. It will not show. You can use +0 to show 0 targets. But If there is join with the customer. It should show the same target everywhere

[Anonymous]

See below for examples.

Target file is a single relationship with the targetkey combined name.

Sales Data looks like this with value & targetkey

 would like target value to display even if there is no targetkey in sales data

[v-zhenbw-msft]

Hi @Anonymous ,

Please allow me to confirm whether my understanding is correct.

You have two tables linked one-to-many based on TargetKey, but the Sales Data table has no matched Target Key.

So you want to display the whole sales even if the Target Key doesn’t match.

Do you want to display the result like this? The no matched sales summarize.

Or do you want to display the result like this, the Sales don’t summarize.

If them don’t meet your requirement, could you please provide a mockup sample based on fake data?

It will be helpful if you can show us the exact expected result based on the tables.

Please upload your files to OneDrive For Business and share the link here. Please don't contain any Confidential Information or Real data in your reply.

Best regards,

Community Support Team _ zhenbw

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Essentially what I need is to have a target for the month showing by customer even if there hasn't been a sale as yet. And if there is a sale for a customer that doesn't have a target it still needs to show.

I have been given a possible solution that I am going to try & will advise if it works