Need help with column structure in Matrix

[TK202_BI]

Hello guys, I have a sample file at: https://www.dropbox.com/s/um8ivikxnawefai/Sample.pbix?dl=0. Can anyone help me make it structured like the figure I have below? Thank you in advance.

[CheenuSing]

Hi @TK202_BI,

It is not possible ot of the box. 

One way I could think of is create a table containing the measure names.  from the sample file posted I created a table called Table1 with Description as column name having two rows with values OrderCount, OrderValue.

Use the Description and Date as columns in the matrix visual.

Created a measure called DisplayMeasure with the formula.

DisplayMeasure = SWITCH( TRUE(), MIN ( Table1[Description]) = "OrderCount", [Invoice Order Count], MIN ( Table1[Description]) = "OrderValue", [PreviousYearINVOICELineAmount] )

Use this DisplayMeasure as Values in the matrix visual.

One key thing to note is the the OrderCount which is a whole number would also get displayed as decimal numbers.

So in this type of workaround, DisplayMeasure should all be aligned to the same format. So what I did was made this DisplayMeasure as wholenumber.  Due to this the OrderValue will be displayed rounded up with no decimals.

Further the data do not have values for 2016 - OrderValues.  SO under the OrderValue you will not see 2016.

Another thing to bear in mind , table and matrix visuals do not support alignment of values. Therefore the readability is questionable. 

I request all those reading this post to vote for the exisiting idea

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/19124698-vertical-column-labels-i...

I am sure the moderators and others In Microsoft would have this functionality be made available soonest, when this is available in PowerPivot in excel.

I am appending the pbix link

https://drive.google.com/open?id=0B-CruXqyozMQQWZaSmtWSkpJcGM

If this works for you please accept this as a solution and also give KUDOS.

Cheers

CheenuSing

[Ashish_Mathur]

Hi,

I don't think that structure is possible.