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 

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.