Forum Discussion
One to Many Relation Ship Issue
- 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".
Hi! vengadesh_p
Try to remove the relationship and create it again. I see the data as you are expecting.
- vengadesh_p1 year agoHelper II
I need to show ID3 with a blank value, also I want to show #Name as Measure