Forum Discussion

netanel's avatar
netanel
Post Prodigy
5 years ago
Solved

matrix problem

Hello everyone! I would be happy to help with two questions 1. Can I combine headings at the top of the column? Like a marge in Excel ( "תושבים כללי"  see pic)   2. I have 4 columns of Value Ho...
Need Help
  • v-yingjl's avatar
    v-yingjl
    5 years ago

    Hi netanel ,

    Question 1:

    Currently Matrix visual could not support combine the same columns into a single column in power bi desktop directly, Matrix visual is a hierarcial visual.

     

    Question 2:

    If you do not want to show the blank in matrix, you can show it as 0 but you need to extract a separate table and create relationship with the source table, then create measures to calculate, below is the example:

    Table 2 = DISTINCT('Table'[Type])

    V1 = SUM('Table'[Value1]) + 0
V2 = SUM('Table'[Value2]) + 0

     

     

     

    Best Regards,
    Community Support Team _ Yingjie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

jaideepnema's avatar
jaideepnema
Solution Sage
5 years ago

Hi netanel ,

For point 1 have you tried creating a calculated column thats basically concats the two required column into one as required ?

 

For point 2 you can apply a not blank visual level filter as shown below 

 

  • netanel's avatar
    netanel
    Post Prodigy
    5 years ago

    Hi 

    jaideepnema

    point one, Not sure I understand what you mean ..
    I want the recurring title to become one connected rather than two separate.( "תושבים כללי" should be one title).

     

     

     

     

    2. I tried it, it does not work in the Matrix table

     

    Thanks!