Forum Discussion
create relationship between 2 Master datas
Hello, currently I'm working with tables with models like this
where the Date table and Master Product table create "1-to-Many" relationship with many tables because the tables have Date and Kode-Produk
Now I want to build a linechart between the tables in the middle with Date table in X axis and they show nothing.
can you suggest me how to create the relationship between this tables so Master Product table can be used to filter product and Date table show for each month
Sorry if my explanation if not clear enough.
Regards
Sandy
Hi Felix, thank you for responding,
after doing some experiments, It seems that my data model is the problem because I do some power query steps to transform the data model (I still don't know how it affect the viz)
but after transformed the data model in excel first and then load it to power query, all the data work well
2 Replies
Hi NewNewNewbie ,
You model seems to be well built looking at your explanation if you add the Master Data in your Axis and the values from the fact tables the filter should propagate within your report.
How are you bulding the visualizations?
Hi Felix, thank you for responding,
after doing some experiments, It seems that my data model is the problem because I do some power query steps to transform the data model (I still don't know how it affect the viz)
but after transformed the data model in excel first and then load it to power query, all the data work well
