View field in both row and column under a year header

[Preacher9296]

I am trying to create a matrix visualizations in which I want to show field value in both row (Actual Value) and its percentage under a year column header. 

[v-xiaotang · Accepted solution]

Hi @Preacher9296 

You need fixed column headings, 

then create the measure like below and put it into Values field

Measure = SWITCH(TRUE(),
MAX('Table'[Column2])="Actual", 1,//replace 1 with your % Rev
MAX('Table'[Column2])="% Rev",2)  //replace 1 with your Actual

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[Preacher9296]

@amitchandak @mangaus1111 @Greg_Deckler @Mikelytics @Jihwan_Kim