Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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 1Project Lvl 2Produkt NameProject Costs
PROJECT000000: AdministrationPROJECT000000_02: AdminConstruction11343
PROJECT000001: ConcretePROJECT000001_01: HoursRig10819
PROJECT000001: ConcretePROJECT000001_02: AdminRig16668
PROJECT000002: SteelPROJECT000002_01: HoursConstruction916
PROJECT000002: SteelPROJECT000002_02: AdminConstruction3206
PROJECT000003: Wood workPROJECT000003_01: HoursConstruction18688
PROJECT000003: Wood workPROJECT000003_02: AdminConstruction55476
PROJECT000003: Wood workPROJECT000003_03: MaterialRig688031

 

 

and i would like to display it like this, with the steped hierarchy in one d

Skjermbilde.PNG

 

 

 

 

1 ACCEPTED SOLUTION
MFelix
Super User
Super User

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_0-1603728237942.png

 


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



View solution in original post

8 REPLIES 8
Anonymous
Not applicable

@MFelix 

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?

 

MFelix
Super User
Super User

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_0-1603728237942.png

 


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Anonymous
Not applicable

@MFelix  only on eissue. When I click on the + sign on the lowest level I get this error.

 

Skjermbilde.PNG

 

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


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Anonymous
Not applicable

@MFelix 

 

Report:

 

Skjermbilde3.PNG

 

 

Visual:

Skjermbilde2.PNG

 

Data:

 

Skjermbilde1.PNG

Hi @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:

 

MFelix_0-1603812340574.png

As you can see I have the blank column in the same table that will work properly.

 


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Anonymous
Not applicable

@MFelix Thanks 🙂

Anonymous
Not applicable

@MFelix  Thank you! That turned out perfectly 🙂

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.