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 s...
Need Help
Tips and Tricks
  • amitchandak's avatar
    amitchandak
    4 years ago

    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 

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

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
    4 years ago

    Thank you! so easy yet unknown

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi,

     

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

    Thanks.