Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 |
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
49 | |
26 | |
21 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |