Forum Discussion
Dynamic matrix visual column headers
We want the column names in the matrix should be dynamic and the data shown should also be dynamic
Snapshot Date | <last year> | <this year> | <next year> | R3M | R6M | R9M | R12M |
| Jan 2021 | 1,755,692 | 2,298,284 | 2,298,284 | 2,298,284 | 2,528,069 | 2,148,843 | 2,148,843 |
| Feb 2021 | 1,755,692 | 1,685,614 | 1,998,530 | 1,998,530 | 2,198,322 | 1,868,608 | 1,868,608 |
| March 2021 | 1,755,692 | 1,685,614 | 1,969,587 | 1,998,530 | 2,198,322 | 1,868,608 | 1,868,608 |
| April 2021 | 1,755,692 | 1,685,614 | 1,969,587 | 1,804,455 | 2,198,322 | 1,868,608 | 1,868,608 |
in the above example <last year>, <this year>, <next year> should show actual year and other column headers are static.
can you please help me with how I can achieve this?
The row data is in the following format
| Snapshot Date | Period | Key figure | Value |
| Jan 2021 | Jan 2021 | k1 | 200 |
| Feb 2021 | Feb 2021 | k2 | 300 |
| March 2021 | March 2021 | k1 | 500 |
| April 2021 | April 2021 | k2 | 550 |
Column headers are based on period year
I can't think of a nice clean way to do this.
For a less clean method, you may be interested in my answer here:
https://stackoverflow.com/questions/52632713/custom-aggregate-column-in-power-bi-matrixHi SonaliDhotre
Not sure, but I think you can use calculated Group.
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/
2 Replies
I can't think of a nice clean way to do this.
For a less clean method, you may be interested in my answer here:
https://stackoverflow.com/questions/52632713/custom-aggregate-column-in-power-bi-matrixHi SonaliDhotre
Not sure, but I think you can use calculated Group.
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/