Forum Discussion
Relationships between 3 or more databases
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?
7 Replies
- Idrissshatila
Super User
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đź’ˇ 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
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đź’ˇ
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..
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.
