matrix problem

[netanel]

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 How do I dont show blanks in columns that have no Value?

[v-yingjl · Accepted solution]

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.

[negi007]

@netanel 

I guess you wish to create a hierarchical view in your data. Currently what I know that power bi does not support hierarchal view of measures. You can create a hierarchy of your dimension data. You can create a hierarchy view like Country->State->City or Year->Quarter->Month->Day. If you have separate columns that you wish to show in the matrix then you can create a hierarchy which will give you the kind of view you wish to have.

https://community.powerbi.com/t5/Desktop/Hierarchy-of-calculated-measures/td-p/117433

https://community.powerbi.com/t5/Desktop/can-we-create-hierarchy-for-measure/td-p/402732

[jaideepnema]

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]

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!