Forum Discussion
Helper IHow to get change the matrix visual column header name dynamically based on slicer
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.
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
2 Replies
- Jihwan_Kim
Super User
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
nbufffJihwan_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)}