How to combine multiple columns in one row expand

[rheims]

I am created a matrix in Power BI with project data.

I have 3 columns of data that show for one project...Project Number, Project Name and Project Mgr.

I want to expand the College & University Focus Market and only see one line .

Here is what I currently get.

This is more what I want to get....

How do I get the 3 columns to show side by side instead of expanding rows under each other?

Thanks!

[bfernandez · Accepted solution]

Hey @rheims 

I beleive what you are trying to accomplish can be achieved by doing the following in the format pane of the matrix:

By toggling the Stepped layout, it will provide everything on one line. You can also chose to toggle off the +/- icons by toggling the feature as well.

If this answers your question, please mark this post as the solution to help others! 😁

[Pragati11]

Hi @rheims ,

Try moving your columns "ProjectNum", "ProjName" and "ProjMgr" to columns section of the Matrix visual and keep column contaning "College & University" in Rows section of a matrix visual.

If this helps please give Kudos and mark this as a Solution! 🙂

Thanks,

Pragati

[rheims]

Since I have lots of projects it just makes those show as one column for each project then.

[Pragati11]

Hi @rheims ,

Can you please share a smaple data?

Thanks,

Pragati