英文:
Category and subcategory tables in power bi matrix visualization
问题
I am looking for help to create a matrix visual in Power BI. I have several lookup and data tables. One of the sample table is:
表格
名称|类别|子类别|数据
A | 类型1 | 子1 | 3
A | 类型1 | 子2 | 4
A | 类型1 | 子3 | 3
A | 类型2 | 子1 | 6
A | 类型2 | 子2
A | 类型2 | 子3
B
B
C
C
I am expecting an output matrix visual with categories and subcategories like below:
期望的矩阵输出
类型1 | 类型2
名称|子1|子2|子3|子1|子2
A. | 3 | 4 | 3 | 6
B. | |
C
As of now, I was able to only create a matrix with either category or subcategory as columns, and the other I used a slicer to filter. Another trial gave me the subcategory each into values or row. But expecting a multi-category table like I have shown. Any help would be appreciated 🙂.
英文:
I am looking for help to create a matrix visual in Power bi. I have several lookup and data tables.One of the sample table is
Table
Name|Category|Sub-category|data
A | Type1 | Sub1 | 3
A | Type1 | Sub2 | 4
A | Type1 | Sub3 | 3
A | Type2 | Sub1 | 6
A | Type2 | Sub2
A | Type2 | Sub3
B
B
C
C
I am expecting an output matrix visual with categories and subcategories like below
Expected output matrix
Type1 | Type2
Name|sub1|sub2|sub3|sub1|sub2
A. | 3 | 4 | 3 | 6
B. | |
C
As of now, i was able to only create matrix with either category or sub category as columns and the other i used a slicer to filter. Another trial gave me the sub-category each into values or row. But expecting a multi-category table like I have shown. Any help would be appreciated 🙂.
答案1
得分: 0
配置矩阵如下图所示，然后单击您的可视化中的红色圆圈图标。这应该解决您的问题。
英文:
Configure the Matrix as shown in the below image and then click on the red circled icon in your visual. This should solve your issue.
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论