Forum Discussion

vengadesh_p's avatar
vengadesh_p
Helper II
1 year ago
Solved

One to Many Relation Ship Issue

Hello Everyone,  I have a table like the image below  Have a connection like this My expected output is  but I'm getting below result  How can I achieve this re...
Need Help
  • powerbiexpert22's avatar
    powerbiexpert22
    1 year ago

    Hi vengadesh_p 

    please follow below steps to get the output, please see below pbix file for your reference

    https://drive.google.com/file/d/16sf3HBGwfC7fN53bkeanKhMZEGN8xvjK/view?usp=drive_link

     

    1. create relationhip between two tables using id column 

    2. use drop down menu on name column and use count distinct as shown below

    3.  use the dropdown menu of id column and select show items with no data as shown below 

     

     

    If there are blank values in visuals, they will be hided by default. It is by design for Power BI. So, after creating relationships, you need to turn on the option "Show items with no data". 

powerbiexpert22's avatar
powerbiexpert22
Impactful Individual
1 year ago

Hi vengadesh_p 

please follow below steps to get the output, please see below pbix file for your reference

https://drive.google.com/file/d/16sf3HBGwfC7fN53bkeanKhMZEGN8xvjK/view?usp=drive_link

 

1. create relationhip between two tables using id column 

2. use drop down menu on name column and use count distinct as shown below

3.  use the dropdown menu of id column and select show items with no data as shown below 

 

 

If there are blank values in visuals, they will be hided by default. It is by design for Power BI. So, after creating relationships, you need to turn on the option "Show items with no data".