Dynamic Column names with Calculation Groups?

[joshua1990]

Hi all!

Is it possible to get dynamic column names in a matrix based on a selected filter / slicer and calculations groups?

For instance I have a matrix that shows this:

Department	KPI 1	KPI 2	Sales Last Week	Sales 2 Weeks ago
A	50	45	6783	2345
B	60	76	4673	4567

On the slicer I have a week number. If I select WK48 then I get in the Column "Sales Last Week" the Sales for WK47.

Is it possible to get this number / text into the column header?

Department	KPI 1	KPI 2	WK47	WK47
A	50	45	6783	2345
B	60	76	4673	4567

[Anonymous]

Hi  @joshua1990 ,

This is the related document, you can view this content:

Dynamic Measure Selection in Power BI - Visual BI Solutions

28 - Change Column name Dynamically on Visuals in Power Bi - YouTube

Solved: Re: Dynamic column header in Matrix - Microsoft Power BI Community

Solved: filtering fields to show - Microsoft Power BI Community

Dynamic Attributes In A Power BI Report - P3 Adaptive

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.