Forum Discussion
Matrix with changeable year column headers
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
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.
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.
