Output table with sub-category

[pey]

Hi All,

I am trying to build a table on GDP breakdown for the US. My table in excel is formatted in such a way that we can easily see the relationship between each column (e.g. Goods is a main category consisting of durable and non-durable goods). How can I do this in power BI without having to number them in ascending order (e.g. 1.0 Goods, 1.1 Durable, 1.2 Non-durable).

[v-yanjiang-msft · Accepted solution]

Hi @pey ,

According to your description, taking the first two categories as an example, I create a table.

In a matrix visual, put all categorie columns in the Rows and all date columns in the Values, expand the rows, get this:

If you want all the dates in one column like below, you can select all date columns and unpivot them in Power Query.

I attach my sample below for reference.

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@pey , Need more info. But calculation group of analyze in excel can help

Power bi Excel for P&L , add in app
Curbal
https://www.youtube.com/watch?v=IISYzTaIyu4
Guyinacube
https://www.youtube.com/watch?v=1yJnmZRTNZg