Forum Discussion

Soc3's avatar
Soc3
Helper I
1 year ago
Solved

Matrix Table- Single Column Value and Previous Year Measure

I have names in the rows (hidden for privacy purposes), dates in the columns and percentages in the values (a measure). I want to add a single column that states what the target is.       H...
Need Help
  • kushanNa's avatar
    kushanNa
    1 year ago

    Hi Soc3 

     

    If you need the Target to appear next to the row value only once, you can create a calculated column with the target and use it as a row, then change the matrix table layout style to Tabular.

     

     

Soc3's avatar
Soc3
Helper I
1 year ago

Hi v-saisrao-msft ,

 

Thanks for your response and the PBI file. This won't work in my scenario due to the drill down of organizational hierarchy in the rows. I have level 2, level 3, level 4, etc to allow leadership to drill through the metrics for each manager. Is there a way to achieve this in columns?

v-saisrao-msft's avatar
v-saisrao-msft
Community Support
1 year ago

Hi Soc3,

Please try moving the issue year field from the rows section to the columns section. See the screenshot below for your reference.

I hope this resolves your issue.

 

Thank you.

  • Soc3's avatar
    Soc3
    Helper I
    1 year ago

    Thank you. Because the previous YR and Target % values don't change each month, is there a way to only show those columns once?

    • v-saisrao-msft's avatar
      v-saisrao-msft
      Community Support
      1 year ago

      Hi Soc3,

      We cannot show these columns only once in the matrix.

       

      Thank you.