Forum Discussion
Dynamic Column names with Calculation Groups?
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 |
1 Reply
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.
