Matrix values in new rows

[Anonymous]

Hello,

I have the following matrix:

But I want something like this:

Forget about the colors, I just want "Receitas"  to becomes a new row instead to be side by side with the "Despesas" row.

My data is organized with the following way:

Tables:  

|  Data/Date   |                     |  Despesas/Profits  |                   | Receitas/Revenues | 

 --------------                          ------------------                        --------------------    

|  mês/month |                     |   VRTOTAL/Value  |                    |    VRTOTAL/Value   |

                                            |      mês/month     |                    |      mês/month       |

                                            |    Valor_Sring¹      |                    |     Valor_String¹      |

1 -- Valor_String is just a a string value containing the name of the table.

And these are my fields:

[Anonymous · Accepted solution]

To fix it, I create a new table named Result, and it contains the difference between Profit's VRTOTAL and Revenues' VRTOTAL, the date and added a new columns with 'Result' as value for all rows.

Then I created a new table like this:

|     NewTable     |

|     month          |

|     VRTOTAL      |

|     Valor_String |

In this new table, I appended all VRTOTAL, month and Valor_String from Profit, Revenues and Result. For example:

NewTable  --> |  month  |  VRTOTAL  |  Valor_String

                             01              100             'revenue'

                             10                30             'revenue'

                             10              100             'result'

                             01              -40             'result'

                             01                60             'profit'

                             10                50             'profit'

And finally, I added this table to a martrix.

[v-ljerr-msft]

Hi @Anonymous,

I don't think there is an easy way to do it currently. Here is a similar idea which requests option to show Matrix Measures or Values on Rows instead of Columns on Power BI Ideas. You can vote it up and add your comments there to improve Power BI on this feature.

Regards