Set Measure above column headers rather than below (which is the usual way to work in a matrix)

Question

Hi Dears,&nbsp;&nbsp;As in an Excel Pivot table, I would like to set measures as column headers.&nbsp;I have two measures :MTD actualsYTD actuals&nbsp;I can easily do a matrix as such, which is the basic and usual way of using a matrix in PB :&nbsp;Column field :&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Company 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Company 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Company 3Measure&nbsp; :&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; MTD actuals&nbsp;&nbsp;&nbsp;&nbsp; YTD actuals&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; MTD actuals&nbsp;&nbsp;&nbsp;&nbsp; YTD actuals&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; MTD actuals&nbsp;&nbsp;&nbsp;&nbsp; YTD actuals&nbsp;Turnover&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 30&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 90&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 62&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;33&nbsp;&nbsp;But I would like :&nbsp;Measure&nbsp; :&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; MTD actuals&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; YTD actualsColumn field :&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Company 1&nbsp; &nbsp; &nbsp; &nbsp; Company 2&nbsp; &nbsp; &nbsp; &nbsp; Company 3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Company 1&nbsp; &nbsp; &nbsp; &nbsp; Company 2&nbsp; &nbsp; &nbsp; &nbsp; Company 3&nbsp;Turnover :&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 30&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;20&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 90&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 62&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;33&nbsp;&nbsp;Question : is there an easy way to do this ? Without creating new tables I mean ?&nbsp;My work around is to do two separate visuals (one for each measure) but it is not what I am looking for.&nbsp;Sincerely,&nbsp;Damien

themistoklis · Answer

Hello&nbsp;DamienBrux&nbsp;&nbsp;Click on Matrix --&gt; Format --&gt; Values --&gt; Show on rows (Turn it on)&nbsp;Image below:

anonymous · Answer

Hi&nbsp;DamienBrux&nbsp;,&nbsp;To my knowledge, your requirement could not be realized currently.&nbsp;But this is at idea/feedback level alone. May be , hopes Power Bi will implement this in nearby future.&nbsp;If you also want this in power bi, let the power bi community know this thing,&nbsp;please publish your idea on the Power BI website -https://ideas.powerbi.com/ideas/&nbsp;&nbsp;Best Regards,Stephen Tao&nbsp;If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

anonymous · Answer

Hi&nbsp;DamienBrux&nbsp;,Sorry to disturb you...But did I answer your question ? Please mark my reply as solution. Thank you very much.&nbsp;Best Regards,Stephen Tao

Forum Discussion

Set Measure above column headers rather than below (which is the usual way to work in a matrix)

3 Replies

Related content

Power BI - Matrix : Column Header Grouping for multiple measures

Dynamic Column Header In a Matrix

Matrix Header Heigth Problem only online

hide matrix headers

Conditional formatting in power bi matrix row headers