Additional row for Matrix table

[Magesen_Muniand]

Hi
How can i show additional row (Staff ID) for matrix table?
in this scenario i wanted to show Staff ID next to Staff Name.
Pls advise. TQ

[Anonymous · Accepted solution]

Thank you shafiz_p and Payeras_BI 

Hi, @Magesen_Muniand 

Based on your description and the screenshots shown, I've created the following sample data:

If you want to add a column next to name, then you need to make a header table:

Sort the name column by sortID:

Create the following three measures:

ID = MAX('Table'[Staff ID])

ProductValue = 
VAR _product = SELECTEDVALUE(HeaderTable[Name])
RETURN CALCULATE( SUM('Table'[Value]),'Table'[Product] = _product)

Measure = SWITCH(TRUE(),
SELECTEDVALUE(HeaderTable[Name]) = "Staff ID",[ID],
[ProductValue]
)

Create a matrix:

How to Get Your Question Answered Quickly

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Payeras_BI]

Hi @Magesen_Muniand ,

I understand you want to drag both 'Staff Name' and 'Staff ID' into the rows of the matrix, then change the layout to 'Tabular' and enable 'Repeat Row Headers' to display it as shown in your picture.

[shafiz_p]

Hi @Magesen_Muniand  Not very clear what you are expecting actually. Share some details about what your expected result in matrix.

Your staff ID already next to Staff Name. Also, You would not be able to create any manual additional rows in maxtrix visual except a blank rows.

If you want to create a blank rows in matrix visual, you can use format option blank rows for spacing. See image below:

Hope this helps!!

If this solved your problem, please accept it as a solution!!

Best Regards,
Shahariar Hafiz

[Magesen_Muniand]

Currently the Matrix table showing as per below :-

Expected to see the Matrix table as per below :-

i need the solution using matrix table, not ordinary table bcoz i need to use dynamic filtering to show the columns. so pls advise the solution as requested for the matrix table. TQ

[shafiz_p]

This is the matrix. Place all the dimension in rows.

After that go to option Layout and Style pressets, change layout from compact to tabular. See image below:

After selecting tabular, you will get your desired result. See image below:

Hope this helps!!

If this solved your problem, please accept it as a solution!!

Best Regards,

Shahariar Hafiz