Table visualization

[LearnPowerBIAS]

Hi friends,

I have a input and showing those in table visual, but its coming like this

Name	Subject	Percentage	Result
Satish	Maths	75	pass
Satish	English	60	pass
Satish	Science	60	pass
Arun	Maths	45	pass
Arun	English	50	pass
Arun	Science	30	Fail
Ella	Maths	45	pass
Ella	English	50	pass
Ella	Science	30	Fail

But I want the result to show like this.

Name	Subject	Percentage	Result
Satish	Maths	75	pass
	English	60	pass
	Science	60	pass
Arun	Maths	45	pass
	English	50	pass
	Science	30	Fail
Ella	Maths	45	pass
	English	50	pass
	Science	30	Fail

Please let me know how to achieve that.

Thanks in advance. 

[FataiSanni · Accepted solution]

Hi,

To achieve the result, you need to use a Matrix Visual, and not a Table Visual. Add Name and Subject to rows; Percentage and Result to Values.

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