Matrix with row depending one each other

[LBoto]

Hi everyone,

I am new here and need help to implement a table like the following image. It reguards revenues current year, past year and budget.

How can it be implemented in a PBI matrix? The row structure in particular seems tricky to me.

Thank you in advance

[amitchandak · Accepted solution]

@LBoto . Use option Switch Values to row/Show  values on rows in matrix visual, with Noting on row and Structure on the column

Or check calculation group Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0 

[Johnny101]

Hi,

Where exactly do I find the "Switch Values to row/Show  values" option? I can't find it in the format panel.

Thanks.

[LBoto]

Thank you! so easy yet unknown