Forum Discussion
Dynamic row headers in matrix visual
Hi all,
I am looking for a way to include dynamic row headers in a matrix visual. I can achieve what I want using paramaters when the parameter is added to a column, but not as a row. It needs to be added as a row.
Kind regards,
Ben.
Hi all,
Apologies I figured out what I was doing wrong. I was trying to use a measure in a parameter, and display this as a row in the matrix. Ended up having to use a connected table. Assuming PowerBi couldn't determine the relationship and therefore drill down to the appropriate level on the row, to display the parameter.
Thanks for your comments though, much appreciated.
Kind regards,
Ben.
4 Replies
Hi bhalicki
The approach depends on what you really want to achieve. You could use field parameters on both the column and row headers. Maybe field parameters isn't the answer. Maybe the use of a disconnected table or two. Or both. There's just not enough information. Please refer to this sticky post - https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
Hi all,
Apologies I figured out what I was doing wrong. I was trying to use a measure in a parameter, and display this as a row in the matrix. Ended up having to use a connected table. Assuming PowerBi couldn't determine the relationship and therefore drill down to the appropriate level on the row, to display the parameter.
Thanks for your comments though, much appreciated.
Kind regards,
Ben.Hi bhalicki ,
I am glad that you could figure out the issue by yourself. Could you kindly mark the helpful reply as the solution?
More people will benefit from it.
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
