Forum Discussion
create header for columns in matrix?
Hi!
I currenly have a data set with many columns I created with DAX (so i am unable to unpivot them)
my columns currently look like this (in a matrix):
| 2021 Orders | 2022 Orders | 2021 Revenue | 2022 Revenue |
I want headers to group "Orders" and "revenue" to clean it up, like this:
Orders Revenue
| 2021 | 2022 | 2021 | 2022 |
How can I do this?
Thank you!
Hi PBINewbie920
In your Matrix table, under the Columns field add Orders and Revenue first, then underneath that addd the Years.
If you're data model is structured appropriately, the above should work. If not, please let us know and we can further assist.
Theo 🙂
1 Reply
Hi PBINewbie920
In your Matrix table, under the Columns field add Orders and Revenue first, then underneath that addd the Years.
If you're data model is structured appropriately, the above should work. If not, please let us know and we can further assist.
Theo 🙂