Forum Discussion

Magesen_Muniand's avatar
Magesen_Muniand
New Member
2 years ago
Solved

Additional row for Matrix table

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
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

     

     

     

     

shafiz_p's avatar
shafiz_p
Icon for Super User rankSuper User
2 years ago

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's avatar
    Magesen_Muniand
    New Member
    2 years ago

    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's avatar
      shafiz_p
      Icon for Super User rankSuper User
      2 years ago

      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