Forum Discussion

LBoto's avatar
LBoto
Frequent Visitor
4 years ago
Solved

Matrix with row depending one each other

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

 

 

 

  • 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 

3 Replies

  • 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 

    • LBoto's avatar
      LBoto
      Frequent Visitor

      Thank you! so easy yet unknown

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hi,

       

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

      Thanks.