Power BI Matrix - show grouped rows as single row

[slw_wills]

Hi

I am a beginner to Power BI so forgive my naive question.  I have a matrix showing number of days against a project by year.  The project has a name and belongs to a group.  In the matrix these grouped columns show on separate rows.  Can I get them to show on a single row.  As the project is unique there can only ever be a single row combination.  I know how I would do this in excel using a pivot table but I can't see how to get the same visual in Power BI.

Matrix in Power BI

Pivot in Excel

Many thanks in advance

[Anonymous · Accepted solution]

Hi @slw_wills ,

Try to turn off the "Stepped layout" option.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.           

[Anonymous · Accepted solution]

Hi @slw_wills ,

Try to turn off the "Stepped layout" option.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.           

[PBIuser73]

Hi.

I have the same issue, but i can not find this option "Stepped layout". 

Do you have any tip for me?

[slw_wills · Accepted solution]

Hi

Thanks for your response, this works perfectly, also added to remove the +/- icons and I get exactly what I wanted.  Perfect.

Thanks again

[slw_wills]

Thanks olgad for your reply.  Shame it doesn't do what I want, but if that is how it is then at least I know I'm not missing a trick.  Thanks again.

[olgad]

Hi, no it is the way Power BI works displaying next level in hierarchy down, you can turn on the row totls to have the totals on the upper levels