Forum Discussion
Dataflow issue
All-
im having issues with my data flow talking across all of my tables.
Im trying to use the date table to sort by month and use the client table to sort by brand. but the brand is only sorting for the totals for the year and not for the individual month. Can someone please tell me how I need to setup the dataflow in order for each of the tables to be able to chat with each other. Below is the a copy of the dataflow as well as a picture of the visualization page. In my head, I imagine that i can use the date table as the center point and then reference the two larger tables of the PDE17 file and the CYBS TR files as fact tables to the date table. . But if I am correct, then all the data should take all the way across the entire flow and a filter in one area will filter the rest of the flow. Correct me if i am wrong on this.
It is good if you follow e.g. star schema in your model. For example all dimension tables like Date should be in single relationship to your fact table/s (one-to-many)
9 Replies
Can you explain what you mean by fix my data model? What could be causing the issue?
Ive spent 8 weeks now trying to self teach Power BI. Not sure if my starting point is screwed up.It is good if you follow e.g. star schema in your model. For example all dimension tables like Date should be in single relationship to your fact table/s (one-to-many)
