blocks|key|479906|text|请找表格关系是单向的还是双向的.如果它是复杂的，你要走两条路，那么它就不会出现。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|479907|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

please find table relation is one-way or two-way . if it is complex and you are going for two way then it will not show.

blocks|key|1776821|text|你的桌子：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1776822|客户|unordered-list-item|1776823|角色|1776824|CustomerInRole|1776825|表"Customer“对于您的报告没有必要，因为您只需要知道"CustomerInRole”中“角色”中每一行的行数。因此，只需添加一个饼图，使用轴(或图例)中角色的名称和"CustomerInRole“中字段”CustomerID“的(不同)计数即可。|1776826|这就是你所需要的;-)|1776827|entityMap^0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|P|8|@]|9|@]|A|$]]|$1|E|3|F|5|D|7|Q|8|@]|9|@]|A|$]]|$1|G|3|H|5|D|7|R|8|@]|9|@]|A|$]]|$1|I|3|J|5|6|7|S|8|@]|9|@]|A|$]]|$1|K|3|L|5|6|7|T|8|@]|9|@]|A|$]]|$1|M|3|-4|5|6|7|U|8|@]|9|@]|A|$]]]|N|$]]

Your Tables:

<ul>
<li>Customer</li>
<li>Role</li>
<li>CustomerInRole</li>
</ul>

The Table "Customer" is not necessary for your Report because you only need to know the count of rows in "CustomerInRole" per row in "Role". So just add a pie chart, use the name of the role in the axis (or legend) and the (distinct) count of Field "CustomerIDs" in "CustomerInRole"

That is all you need ;-)

blocks|key|1776918|text|为了让事情变得清楚，我会把这个角色添加到您的客户的表中。当您开始使用BI时，以关系的方式保持它是没有用的。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1776919|这可以很容易地在查询编辑器中完成。在home选项卡上，单击“编辑查询”。|1776920|📷|atomic|offset|length|1776921|​|1776922|在那里，您必须单击“合并查询”，也可以在右侧的home选项卡上完全单击。|1776923|1776924|1776925|在上表中，选择CustomerID列和Customer_CustomerRole_Mapping表，为该表选择正确的ID。单击“确定”后，可以展开新列(右击合并查询列)。您必须重复这个步骤才能将角色添加到Customer表中，但是在第二轮中，您必须使用selectint的roleId。|1776926|在这之后，您可以从这个表中删除不再需要的列，只需保留该角色即可。|1776927|然后在饼图中添加角色并选择"Count“。|1776928|如果您有其他事实表，并且您希望使用角色作为维度，那么像这样解决它是很方便的。|1776929|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://developer.qcloudimg.com/http-save/yehe-900000/a909c18595c723f5899837d09e0cf874.png|imageAlt|1|https://developer.qcloudimg.com/http-save/yehe-900000/4836cece7e8131929c94871703965957.png^0|0|0|0|1|0|0|0|0|0|1|1|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|17|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|18|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|19|8|@]|9|@$G|1A|H|1B|1|1C]]|A|$]]|$1|I|3|J|5|6|7|1D|8|@]|9|@]|A|$]]|$1|K|3|L|5|6|7|1E|8|@]|9|@]|A|$]]|$1|M|3|E|5|F|7|1F|8|@]|9|@$G|1G|H|1H|1|1I]]|A|$]]|$1|N|3|J|5|6|7|1J|8|@]|9|@]|A|$]]|$1|O|3|P|5|6|7|1K|8|@]|9|@]|A|$]]|$1|Q|3|R|5|6|7|1L|8|@]|9|@]|A|$]]|$1|S|3|T|5|6|7|1M|8|@]|9|@]|A|$]]|$1|U|3|V|5|6|7|1N|8|@]|9|@]|A|$]]|$1|W|3|-4|5|6|7|1O|8|@]|9|@]|A|$]]]|X|$Y|$5|Z|10|11|A|$12|13|14|-4]]|15|$5|Z|10|11|A|$12|16|14|-4]]]]

To have things clear I would add the role to your customer's table. There's no use in keeping things in a relational way when you start playing with BI. 

This can easily be done in the query editor. On the home tab, click "Edit Queries"
<a href="https://i.stack.imgur.com/GBXYg.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/GBXYg.png" alt="Edit Queries"></a>

And there you'll have to click "Merge queries", also on the home tab completely on the right. 
<a href="https://i.stack.imgur.com/MKn50.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/MKn50.png" alt="Merge queries"></a>

In the upper table you select the CustomerID-column and Customer_CustomerRole_Mapping table, select the right ID for that table. After clicking "Ok" you can expand the new columns (by right clicking the merged query-column). You will have to repeat this step to add the roles to the Customer table, but in this second round you will have to work with selectint the roleId's. 

After all this you can delete the columns that you don't need anymore from this table and just keep the role. 

In the pie chart you then just add the role and select "Count".

It is handy to solve it like this when you have other Fact-tables, and you want to use Role as a Dimension.

blocks|key|1776988|text|您可以链接power+bi桌面上的表、转到仪表板并单击第三个菜单，在图像关系管理数据表映像中显示任何您想要的与表的关系，只需拖放多个表和单个表中的父表和子表之间的链接，如果要删除这种关系，只需按关系箭头(行)，右键单击联机并删除它并保存文件。干杯。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1776989|entityMap|0|LINK|mutability|MUTABLE|url|https://i.stack.imgur.com/6KSS2.png^0|10|9|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

You can be linking of tables in power bi desktop go dashboard and click on the third menu as showing in image <a href="https://i.stack.imgur.com/6KSS2.png" rel="nofollow noreferrer">Relation Management data table image</a> whatever you want make relation with table just drag and drop to link within multiple and single tables with parent and child tables and if you want to delete this relation just go on relation arrow(line) do right click on line and delete it and save file.
Cheers.

In power bi, I have a table <code>Customer</code> in which I am keeping the Id, name and other details of customer. I have another table named <code>Customer_CustomerRole_Mapping</code> which contains CustomerId and its CustomerRoleId. I have another table name <code>CustomerRoles</code> which contains name and id of each role.

<code>CustomerRoles</code> and <code>Customer_CustomerRole_Mapping</code> are linked together.

In Power Bi, I want to show customers count role wise in a pie chart? I tried but I am unable to apply linkage between these tables. I am new to Power Bi.

Power Bi: Link Tables

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

在power bi中，我有一个表Customer，其中保留了客户的Id、姓名和其他详细信息。我有另一个名为Customer_CustomerRole_Mapping的表，它包含CustomerId及其CustomerRoleId。我有另一个表名CustomerRoles，它包含每个角色的名称和id。CustomerRo...

问Power Bi:链接表
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问Power Bi:链接表EN