Forum Discussion
Convert multiple column values to rows
Well... I created a new calculated column:
Area# = "Area" & RIGHT ( Data[Area], 1 )and placed it in the column field in the matrix visual.
Then created a new measure and added it to the matrix values:
MyValues = IF ( ISINSCOPE ( Data[ID] ), VALUES ( Data[Result] ), VALUES ( Data[Area] ) )In the Matrix Row I added both the Type and ID.
In Power BI file options, I disabled the use of modern visual headers.
And in the matrix visual format, I adjusted the subtotals as follows:
and made the column headers white (same as background to make them invisible).
Please check this sample file.
Well... I created a new calculated column:
Area# = "Area" & RIGHT ( Data[Area], 1 )
and placed it in the column field in the matrix visual.
Then created a new measure and added it to the matrix values:
MyValues =
IF (
ISINSCOPE ( Data[ID] ),
VALUES ( Data[Result] ),
VALUES ( Data[Area] )
)
In the Matrix Row I added both the Type and ID.
In Power BI file options, I disabled the use of modern visual headers.
And in the matrix visual format, I adjusted the subtotals as follows:
and made the column headers white (same as background to make them invisible).
Please check this sample file.
Hi. Thanks you again and this is brilliant solution. You provide new solutions for more than one layer of column headers in matrix visual.
Can you please advise one more thing here, if I changed the settings based on the your advice it don't affect exiting visual reports?
It is independent from other visuals as we calculated a custom value specifically for this visual (MyValues measure)
#update: disabling modern visual headers will affect all your visuals.