Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello everyone,
Greetings!!!
I'm looking support for the below topic
- I am having below two tables with one to many relationship activated. I like to have a table visualization that shuould have combination of two
input :
Table1 |
Code |
A |
B |
C |
D |
Table2 | |
Code | Description |
A | Name1 |
B | Name2 |
C | Name3 |
Name4 | |
Name5 | |
Name6 |
Result I am getting in table visualization | |
Code | Description |
A | Name1 |
B | Name2 |
C | Name3 |
D | |
Name4 | |
Name5 | |
Name6 |
Result I Need | |
Code | Description |
A | Name1 |
B | Name2 |
C | Name3 |
D |
I learnt that we can use join functin in power query window but i like to undersatand, is there any other method availble in visualizatiom
Thanks,
Santhosh R
Solved! Go to Solution.
Hi,
Use table matrix and drag elements from second table.
(Code and Description )
Now use filter pane , go code and untick blanks.
You get the result.
Kindly mark as solution and thumps up for keeping community healthy
@saravanan_p Thats tricky and seems to be simple. @santhoshrama Kindly mark this as solution. Thanks
Hi,
Use table matrix and drag elements from second table.
(Code and Description )
Now use filter pane , go code and untick blanks.
You get the result.
Kindly mark as solution and thumps up for keeping community healthy
Hello,
Thank you..it's a simple & easy solution
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |