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.

     

     

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

Hi Soc3,

Thank you for reaching out to the Microsoft fabric community forum.

I have recreated your scenario using sample data. Please find the attached PBIX file for your reference.

Hope this helps.

 

Thank you.

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.