Forum Discussion
Output table with sub-category
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).
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 _ kalyjIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
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=1yJnmZRTNZgHi 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 _ kalyjIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
