How to get change the matrix visual column header name dynamically based on slicer

[nbufff]

Hi, I stuck on my case by showing matrix visual header name dynamically based on slicer selection.

I have a table with below information.

I added a slicer to select the version. e.g. if I choose version A. the matrix table will show vs and "Version A" Qty, if I choose version B, the same matrix table will show vs and "Version B" Qty.  Pls give a hint how to achieve that? Thanks.

[Jihwan_Kim · Accepted solution]

Hi,

Please check the below picture and the attached pbix file.

One of ways is to implement field parameter.

Use report readers to change visuals - Power BI | Microsoft Learn

[nbufff]

@Jihwan_Kim , thanks for your solution. It works for me. Just one question: if I have more than 100 versions, is there any way to set the paramter dynamically as well? Thanks!

e.g. 

Parameter = {

    ("A", NAMEOF('Data'[version A]), 0),

    ("B", NAMEOF('Data'[version A]), 1),

    ("C", NAMEOF('Data'[version A]), 2)

...   

   ("AAA", NAMEOF('Data'[version A]), 100)

}