Forum Discussion

pey's avatar
pey
Frequent Visitor
4 years ago
Solved

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 ca...
Need Help
  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    4 years ago

    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.