Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to Solution.
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:
Result below:
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsAnother 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?
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:
Result below:
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em Português@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.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @Anonymous ,
I have the exact same setup and everything is working properly, except when I do one thing that is to have the blank value from another table that will return the same error you data should look like this:
As you can see I have the blank column in the same table that will work properly.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsUser | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |