Fields from column to row

[Aron]

Hi

I have an issue with the way PowerBi shows the fields. In the query editor I made a table with 3 columns, with headers: month, amount and a description of the income statement item. I unpivoted the income statement, therefore there are multiple rows for every item to show the amount in every month. Basically the income statement over multiple months. Very simple.

The problem happens when I go to create a rapport. The fields I can choose from only shows the three column headers (description, month and amount), not the lower level (januari, februari, march etc.). This is useless, because I want to choose the different items (revenue, profit, costs etc.) and see how they are doing over the months. Filters could be used I guess, but revenue as a field item too. I just can't figure out how.

Hopefully someone can help me with this.

Thanks in advance!

[Greg_Deckler]

Can you provide sample data? I'm not sure I follow your issue. If you put Month field into a table or matrix, it will display the values there and then if you add other fields, they will be in the context of the row. So if you use a matrix, it should group the way you want. Some sample data and a sample of desired outcome would help.