Forum Discussion
Combine matrix and table
I have a matrix with a project hierarchy in one column, but is it possible to also show parametres in a second column?
The data looks like this:
| Project Lvl 1 | Project Lvl 2 | Produkt Name | Project Costs |
| PROJECT000000: Administration | PROJECT000000_02: Admin | Construction | 11343 |
| PROJECT000001: Concrete | PROJECT000001_01: Hours | Rig | 10819 |
| PROJECT000001: Concrete | PROJECT000001_02: Admin | Rig | 16668 |
| PROJECT000002: Steel | PROJECT000002_01: Hours | Construction | 916 |
| PROJECT000002: Steel | PROJECT000002_02: Admin | Construction | 3206 |
| PROJECT000003: Wood work | PROJECT000003_01: Hours | Construction | 18688 |
| PROJECT000003: Wood work | PROJECT000003_02: Admin | Construction | 55476 |
| PROJECT000003: Wood work | PROJECT000003_03: Material | Rig | 688031 |
and i would like to display it like this, with the steped hierarchy in one d
Hi Anonymous ,
To what I can see from the image you provide you want to have an additional row in the headers but the value in the values.
Add a column with blank values to your model then just put your matrix in the following setup:
- Rows:
- ProjectsLevel1
- ProjctsLevel2
- BlankColumn
- Values
- FirstProduct Name
- Sum ProjectCosts
- Turn off subtotals
Result below:
- Rows:
8 Replies
Hi Anonymous ,
To what I can see from the image you provide you want to have an additional row in the headers but the value in the values.
Add a column with blank values to your model then just put your matrix in the following setup:
- Rows:
- ProjectsLevel1
- ProjctsLevel2
- BlankColumn
- Values
- FirstProduct Name
- Sum ProjectCosts
- Turn off subtotals
Result below:
MFelix Thank you! That turned out perfectly 🙂
MFelix only on eissue. When I click on the + sign on the lowest level I get this error.
Do you know how I can work around this? The model is simple with everything in the same table, just used for this example.
Hi Anonymous ,
On the lowest level as you can see from my visualization there is no + sign, can you tell me what are the columns you are using for the hierarchy on row level.
- Rows:
Another problem occured, because I do not have access to create new columns in the dataset.
Is there a DAX-formula that can do the same trick?