Forum Discussion

NewNewNewbie's avatar
NewNewNewbie
Frequent Visitor
2 years ago
Solved

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 an...
Need Help
Tips and Tricks
Tutorial Requests
  • NewNewNewbie's avatar
    NewNewNewbie
    2 years ago

    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

MFelix's avatar
MFelix
Icon for Super User rankSuper User
2 years ago

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?

  • NewNewNewbie's avatar
    NewNewNewbie
    Frequent Visitor
    2 years ago

    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