Matrix with Hierarchical column header

[Denis_Slav]

Hi All, 

How can I create hierarchical headers in matrix? 

For example, I've got the current view:

	2020		2021
Channel	Spots per block AVG	Spots per block MAX	Spots per block AVG	Spots per block MAX
ABC	123	123	123	123

I'd like to change view to:

	Spots per block
	AVG		MAX
Channel	2020	2021	2020	2021
ABC	123	123	123	123

Where [Spots per block AVG] & [Spots per block MAX] it's measures. 

I know, that I could move measures to rows, but I need exact hierarchical in columns headers.

[PaulDBrown]

Does the header structure have to be dynamic? if , so, under which cirteria?

[Denis_Slav]

No, in this case it should be fixed. But if it possible to create dynamical, it may be usefull for future.

[Greg_Deckler · Accepted solution]

@Denis_Slav Maybe: The New Hotness (Custom Matrix Hierarchy) - Microsoft Power BI Community

[Denis_Slav]

Thanks. Yes, it looks what I need! Go to analyze, how to adopt it for my task. )