Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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êsCovering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
93 | |
77 | |
65 | |
53 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |