Forum Discussion
A Challenge: How to show additional attribute/reference data columns in a Matrix
Hi. Anyone has any ideas on how to produce a visualization like below? Basically a Matrix, but with several reference columns per roww, before the repeating Matrix columns. Thank you.
| JAN (columns) | FEB | ..... | ||||||
| ID (row) | Title | HourlyRt | Type | HOURS | PAY | HOURS | PAY | |
| A | Student | 10.00 | H | 10 | 100.00 | 15 | 150.00 | |
| B | Teacher | 20.00 | H | 50 | 1,000.00 | 40 | 2,000.00 | |
| C | Officer | 25.00 | O | 50 | 1,250.00 | 35 | 1,750.00 | |
| D | Physician | 100.00 | S | 60 | 6,000.00 | 50 | 3,000.00 | |
| E | Lawyer | 200.00 | S | 40 | 8,000.00 | 30 | 1,200.00 | |
Step 1: I make 3 data tables below and add relationships in Power BI Desktop.
'ID' Table:
ID Title
A Student
B Teacher
C Officer
D Physician
E Lawyer'HourlyRt' Table:
Title HourlyRt Type
Student 10 H
Teacher 20 H
Officer 25 O
Physician 100 S
Lawyer 200 S'Date' Table:
ID HOURS Date
A 10 2023/01/01
B 50 2023/01/15
C 50 2023/01/08
D 60 2023/01/08
E 40 2023/01/25
A 15 2023/02/01
B 40 2023/02/23
C 35 2023/02/09
D 50 2023/02/27
E 30 2023/02/11
A 10 2023/03/01
B 20 2023/03/02
C 30 2023/03/03
D 40 2023/03/04
E 50 2023/03/05Step 2: I make a measure.
Step 3: I make a matrix and change options of the matrix.
+/- icons: on --> off
Stepped layout indentation: on --> off
3 Replies
Anonymous It's possible but ugly. The New Hotness (Custom Matrix Hierarchy) - Microsoft Fabric Community
Thanks. Not to say, It is a little complicated for newbies like me! Let me see if I can get my head wrapped around it... In the meanwhile,
Does PowerBI support something like this? Run a code snippet when visualization refreshes/opens. The code populates a structure with a set of fields (all elements that are needed to define a table). Then the structure is dynamically used to display both a table and a slicer. The slicer can be used to toggle individual columns on/off, allowing the user to fine tune what is displayed....
Step 1: I make 3 data tables below and add relationships in Power BI Desktop.
'ID' Table:
ID Title
A Student
B Teacher
C Officer
D Physician
E Lawyer'HourlyRt' Table:
Title HourlyRt Type
Student 10 H
Teacher 20 H
Officer 25 O
Physician 100 S
Lawyer 200 S'Date' Table:
ID HOURS Date
A 10 2023/01/01
B 50 2023/01/15
C 50 2023/01/08
D 60 2023/01/08
E 40 2023/01/25
A 15 2023/02/01
B 40 2023/02/23
C 35 2023/02/09
D 50 2023/02/27
E 30 2023/02/11
A 10 2023/03/01
B 20 2023/03/02
C 30 2023/03/03
D 40 2023/03/04
E 50 2023/03/05Step 2: I make a measure.
Step 3: I make a matrix and change options of the matrix.
+/- icons: on --> off
Stepped layout indentation: on --> off
