Forum Discussion

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    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-in-table-and-matrix

     

    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