2 different columns in matrix grouped

[natasha519]

Is there a way to get the tier column like below in a table or matrix format?

Tier	Project Number
Tier 1	123
	234
	789

instead of having the tier repeat for each row?

Tier	Project Number
Tier 1	123
Tier 1	234
Tier 1	789

Note: there are multiple tiers, tier 1,2,3 and I would like the project number to align to each tier

[Anonymous]

Hi @natasha519 ,

Put both tier and project number to rows field in matrix and drill down the visual.

Best Regards,

Jay

[lbendlin]

That should be standard behavior for matrix visuals.  Please provide sanitized sample data that fully covers your issue.

Please show the expected outcome based on the sample data you provided. Screenshots of the expected outcome are ok.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523