topic Re: Dynamic matrix visual column headers in DAX Commands and Tips

Dynamic matrix visual column headers

SonaliDhotre — Fri, 17 Dec 2021 21:05:29 GMT

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

Re: Dynamic matrix visual column headers

AlexisOlson — Fri, 17 Dec 2021 21:23:49 GMT

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-matrix

Re: Dynamic matrix visual column headers

VahidDM — Sat, 18 Dec 2021 03:50:37 GMT

Hi 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/