Solved: Categorization of data and background color - Page 2

IF · ‎08-24-2020

Hi,

I want to use a visual that shows salary vs. performance. I have the Result table:

ID	Performance	Salary
A12	40	15000
A23	45	15000
A22	55	18000
A14	60	16000
A16	65	15000
A31	100	20000
A32	90	18000
A33	90	16500
A34	95	17000
A35	70	16000
A36	75	17000
A37	80	15000

I want to group them:

Salary	<10000	Low
	10001-14000	Normal
	14001-18000	High
	>18001	Very High

Performance	<50	Low
	51-65	Normal
	66-85	Good
	>86	Very Good

And I want to show them in power bi:

I tried with scatter chart and used a background image but it didn't work. Do you have any opinion how I could do it?

All the best,

Fowmy · ‎08-25-2020

@IF

There are no visuals that can show the layout you need as far as I checked. The matrix solution I provided should work well enough for you. I have added the tooltip using a tooltip page and you can include other information as well. Hope you can accept this for your solution.

You can download the file: HERE

________________________

If my answer was helpful, please mark this post as a solution, this will also help others!.

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube
LinkedIn

Did I answer your question? Mark my post as a solution! and hit thumbs up

⭕ Subscribe and learn Power BI from these videos

⚪ Website ⚪ LinkedIn ⚪ PBI User Group