A Challenge: How to show additional attribute/reference data columns in a Matrix

[Ibrahim66]

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

[mickey64 · Accepted solution]

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/05

Step 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

[Greg_Deckler]

@Ibrahim66 It's possible but ugly. The New Hotness (Custom Matrix Hierarchy) - Microsoft Fabric Community

[Ibrahim66]

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....