Forum Discussion

Quiny_Harl's avatar
Quiny_Harl
Icon for Advocate III rankAdvocate III
3 years ago

Dynamic row in a matrix

Hi PBI folks,


Is there a way to have a dynamic row in a matrix visual?
Assume I have a matrix with the following fields in Rows and a bunch of measures in Values.

Company      Year-Month Reference Period Vendor

I also have a slicer which is used for dynamic measures:

I would like my Reference Period row also to be dynamic so that when I select CC7, it shows the values from column CC7, when I select M1 it shows the values from column M1 and so on. 

Need Help

1 Reply

  • Quiny_Harl's avatar
    Quiny_Harl
    Icon for Advocate III rankAdvocate III
    3 years ago

    Of couse that it works with Field Parameters, excuse my ignorance 🙂
    However, there is a bug. If I expand the matrix and then click on the slicer that controls my dynamic row, the matrix is automatically collapsed to the level of the dynamic row. I created an idea for this bug. Please, vote for it. Thank you!