Relationships between 3 or more databases

[Neok]

Hi,

I would like to show a stacked column where I can show my Hours (planned hours) + Opportunitieshours (my hours in quote) due advisorygroup.

The issue is that I can show my (planned) Hours, but my Opportunitieshours aren't right. See image below:

I think it has something to do with my relationships between datasets, but i'm not sure. Can anybody help?

[Neok]

Somebody?🙏

For example, I filter the rows of february. It counts every value in the column and shows the sum of it in the graphic. 

The sum of above is 227,5

As you can see it shows 227,5 hours each column, but it has to show it separate of each advisory group.

[Neok]

I just changed the relationship in to this:

This is what i got in my graphic:

I've been reading the link you sended, but I do not really understand it..

[Neok]

Hi @Idrissshatila,
Thanks, This is what i got now, but the value in the graphic it's still the same..

[Idrissshatila]

@Neok ,

You should link the date table to both tables that you're getting your data from and remove them link between these two fact tables.

learn more about star schema data modeling https://learn.microsoft.com/en-us/power-bi/guidance/star-schema

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote For my Idea💡

[Neok]

This is the relationship, in both columns are the names of the advisory groups mentioned

[Idrissshatila]

Hello @Neok ,

Try creating a dim date  table and link it to both tables then view the amounts by this new table.

check this on how to create it https://youtu.be/BnqtBxGbo0M?si=cVeZjs9R2g6SuVrS

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote For my Idea💡

[Idrissshatila]

Hello @Neok ,

are both table have a relationship with the date table that you're using for x-axis ?

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote For my Idea💡