Forum Discussion
Anonymous
6 years agoNot applicable
Trying To Create A Table with Multiple Headers
Hi All,
I am trying to create the below table in Power Bi. I have created the table and the values are fine. Is it possible to create multiple level of headers like "Total Savings","Actual","Fy Committed", etc..
| Category | Spend | Total Savings | P&L Savings | ||||||||
| Plan | Actual | Plan | Actual | ||||||||
| YTD | % | Fy Committed | % | YTD | % | Fy Committed | % | ||||
| Digital Services | 10b | 8b | 23 | 2% | 12 | 4% | 4b | 32 | 10% | 12 | 5% |
| General Services | 15b | 6b | 12 | 3% | 14 | 5$ | 5b | 25 | 2% | 14 | 4% |
Thanks in advance for help
Regards
Ankhi
- Anonymous6 years ago
Hello-
If you place multiple categorical variables in the "Columns" section of your matrix, it will allow you to both drill down to that level and see it expanded at that level.
Jared
1 Reply
- AnonymousNot applicable
Hello-
If you place multiple categorical variables in the "Columns" section of your matrix, it will allow you to both drill down to that level and see it expanded at that level.
Jared