Forum Discussion
Helper IIIMatrix with changeable year column headers
Dear Super Users
I am trying to make a matrix table with 3 years sales values.
Currently, I use table visuals with three headers, Current Year, Last Year, 2Yrs Ago.
However, users sent a request to me to change the header to real years, like 2021, 2020, and 2019.
There is a slicer to change years, so I cannot input a text.
I have reviewed some videos that were using unpivot table function, but I don't want to use it because the data is too big.
Is there a simpler way I can have dynamic column headers in Matrix visual?
2019 | 2020 | 2021 | 21-20 Growth | %Grw 21-20 | % A Group | % B Group |
Those are the column headers that I want. Anybody can help me?
Young_G_Han , Please check my video where I have shared how can do this using an independent data table, but you have default slicer on this year.
Also, this growth % need to be with measure(repeat together), else you need a Hybrid table
Rolling display with selected value
https://www.youtube.com/watch?v=44fGGmg9fHI
Default to this year: https://www.youtube.com/watch?v=hfn05preQYA
Hybrid table
if you are looking for a Hybrid display with Matrix Column and measure
https://community.powerbi.com/t5/Community-Blog/Creating-a-custom-or-hybrid-matrix-in-PowerBI/ba-p/1354591
https://community.powerbi.com/t5/Quick-Measures-Gallery/The-New-Hotness-Custom-Matrix-Hierarchy/m-p/963588#M428vote for Hybrid Table
https://ideas.powerbi.com/ideas/idea/?ideaid=9bc32b23-1eb1-4e74-8b34-349887b37ebc
4 Replies
- amitchandak
Super User
Young_G_Han , Please check my video where I have shared how can do this using an independent data table, but you have default slicer on this year.
Also, this growth % need to be with measure(repeat together), else you need a Hybrid table
Rolling display with selected value
https://www.youtube.com/watch?v=44fGGmg9fHI
Default to this year: https://www.youtube.com/watch?v=hfn05preQYA
Hybrid table
if you are looking for a Hybrid display with Matrix Column and measure
https://community.powerbi.com/t5/Community-Blog/Creating-a-custom-or-hybrid-matrix-in-PowerBI/ba-p/1354591
https://community.powerbi.com/t5/Quick-Measures-Gallery/The-New-Hotness-Custom-Matrix-Hierarchy/m-p/963588#M428vote for Hybrid Table
https://ideas.powerbi.com/ideas/idea/?ideaid=9bc32b23-1eb1-4e74-8b34-349887b37ebc 
Young_G_HanThank you. I have reviewed the posting already which is the same link you give me. I partly understand and try to improve for my own needs. I will study more about it.
Yes, The hybrid table function is very needed.
Have a good day!
- Jihwan_Kim
Hi, Young_G_Han
Please correct me if I misunderstood your question.
I am not sure if there is a way to dynamically change the column header name, however, I think you can try to use the calculation group by using Tabular Editor in Power BI.
The below picture is what I have created by using just a very simple sample data, and readers can select whatever measure they want to see.
the link to the sample pbix file is down below, and please try to have a look.
https://www.dropbox.com/s/l1t7cgqgscuozdf/sample%20april.pbix?dl=0
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster.
- Young_G_Han
It is a little bit different from my needs. What I need is... When I select a month or a year, the table shows all relevant data. Let's say, I select the year 2021, the table shows the sales amount of 2019, 2020 and 2021. And also showing the % growth of the current year, the % mix of product group A and B. This is what I want.
Anyways, thank you for your help.
