Need Help

[Bansi008]

Hi there,

After transforming the data, i used table visualization to create PowerBI dashboard but I am getting output as per below.

Sector	Term Mat	Mat2
Government	Long	15+
Government	Short	5-
Government	Medium	05 to 15
Non-Government	Short	5-
Non-Government	Long	15+
Non-Government	Medium	05 to 15
Other	Long	15+
Other	Short	5-

However, I want output something like this.

Sector	Term Mat	Mat2
Government	Long	15+
Short	5-
Medium	05 to 15
Non-Government	Short	5-
Long	15+
Medium	05 to 15
Other	Long	15+
Short	5-

Can someone please advise how i can merge and center the column sector in the PowerBI dashboard. 

Thanks!

[ChiragGarg2512 · Accepted solution]

@Bansi008 , use the matrix visual, in customization go to row headers and switch off the option for stepped layout.

[Bansi008]

I am pasting a screenshot of the current and expected outputs for better understanding since I see my tables are not pasted properly in the above summary.