Forum Discussion

dzakyramadani's avatar
dzakyramadani
Regular Visitor
6 months ago
Solved

One to Many Relationship Problem

Im trying to create a table that list all value from table 1(combination of LOB, Division, Dept) and add information based on Table2(Fact table). Ive made a compositekey to bridge the combination of ...
Need Help
  • v-achippa's avatar
    v-achippa
    6 months ago

    Hi dzakyramadani,

     

    Thank you for reaching out to Microsoft Fabric Community.

     

    Thank you cengizhanarslan and mh2587 for the prompt response. 

     

    Based on your description this is expected behavior. Even with a correct one to many relationship, power bi visuals will only show dimension rows that have matching fact rows when any column from the fact table is used in the visual or slicer.
    Relationship direction controls only filter propagation. To keep all dimension rows visible, use only Table1 columns in rows and return fact data only through measures.

     

    Thanks and regards,

    Anjan Kumar Chippa

v-achippa's avatar
v-achippa
Community Support
6 months ago

Hi dzakyramadani,

 

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution I have provided for the issue worked? or let us know if you need any further assistance.

 

Thanks and regards,

Anjan Kumar Chippa

v-achippa's avatar
v-achippa
Community Support
6 months ago

Hi @dzakyramadani,

 

We wanted to kindly follow up to check if the solution I have provided for the issue worked? or let us know if you need any further assistance.

 

Thanks and regards,

Anjan Kumar Chippa