Forum Discussion
How to repeat particular column in power BI
- 1 year ago
Hi Aartibhilare
There are two fundamentally different options for repeating a value in a matrix table.
Option 1:
Create a hierarchy. This will always appear at the beginning, followed by what was suggested here using the Tabular layout—this is the approach.Option 2:
Use an aggregate value. If you use functions like MAX/MIN on a text field, you'll get a filtered value at the row level displayed in the matrix.In your last image, there seems to be some kind of horizontal continuity, and it looks like the matrix is displayed across multiple columns. This is something that cannot be achieved with a single matrix in Power BI.
It might be possible to create something like this in Report Builder, but I’m not experienced enough with that tool to guide you on how to do it.
My pbix with the example is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
not sure if you can replicate those format in matrix visual PBI nor to repeat only certain column in matrix visual.
But @Bibiano_Geraldo and other PBI expert might know.
Thank you.