Forum Discussion
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 How do I dont show blanks in columns that have no Value?
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]) + 0Best 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.
4 Replies
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
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!
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
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]) + 0Best 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.
