Matrix with changeable year column headers

[Young_G_Han]

  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?

[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.

[Young_G_Han]

Thank 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!

[amitchandak · Accepted solution]

@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/1...
https://community.powerbi.com/t5/Quick-Measures-Gallery/The-New-Hotness-Custom-Matrix-Hierarchy/m-p/...

vote for Hybrid Table
https://ideas.powerbi.com/ideas/idea/?ideaid=9bc32b23-1eb1-4e74-8b34-349887b37ebc