Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hi all. If you remember, you recently helped me with charts: https://community.powerbi.com/t5/Desktop/Help-with-graphing/m-p/935467#M448160
Now everything is complicated. I have two tables with data. They have the same managers. How can I do the same as in the previous task, only considering the manager from two tables. I attach the screenshots below. I tried to solve the problem, as shown in the screenshots, but it does not work. Thanks for the help earlier.
I also tried to make a separate table of managers and a separate table of "ifnotselected", and after that I created a third table from the above tables. It still didn't work.
Solved! Go to Solution.
This is going to sound terrible, and I apologise upfront, but would it be possible to see a mockup of the screenshots (tables and relationships) with the relevant fields in english? I have tried zooming into the images to try to make out which fields are connected in each table but I haven't been able to make them out (and the unfamiliar language characters make it very difficult to identify fields).
I'm sorry to have to ask for this, but as it is, I can't help you out.
Proud to be a Super User!
Paul on Linkedin.
Hi. Thanks for your reply. I can hardly translate into English, but I will try to describe the specific layout more specifically. Actually, this is the problem, I attached a link to the previous problem to the post, which was successfully resolved. The essence of the problem was that when not one person was selected in the manager section, their indicators were summarized, and when 1 of them was selected, then they showed his indicators. Now the problem is as follows. I have 2 tables. I need to connect them, so that the actions described above are performed. I tried to solve as follows. Make shared tables and display data, however this did not work. I will try to make a layout.The first link shows a project in which everything works. On the second link, what I want to do, but it doesn’t work out for me.
https://www.dropbox.com/s/lqobqvv7twn16zh/123.pbix?dl=0
https://www.dropbox.com/s/qulotm0fhjzi95b/1234.pbix?dl=0
I found solution. TY all.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
89 | |
87 | |
82 | |
64 | |
49 |
User | Count |
---|---|
124 | |
110 | |
88 | |
68 | |
66 |