Forum Discussion

Soc3's avatar
Soc3
Icon for Helper I rankHelper 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
Icon for Helper I rankHelper 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
Icon for Community Support rankCommunity 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.