Forum Discussion

Aartibhilare's avatar
Aartibhilare
Icon for Helper III rankHelper III
1 year ago
Solved

How to repeat particular column in power BI

Hi team i have report like below i want to repeat the  from 2 onwards  like it should be like below but not first column thanks for help let me know if any solution on same
  • Ritaf1983's avatar
    Ritaf1983
    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.