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.

v-yingjl's avatar
v-yingjl
Community Support
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.