Categorization of data and background color

[IF]

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]

@IF 

What do you need to show on the chart? is the count of employees who fall into each corresponding category or anything else?

________________________

Did I answer your question? Mark this post as a solution, this will help others!.

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

YouTube, LinkedIn

[IF]

Thanks for the answer. I want to show the values for salary and performance for each person.

However I want have a background colour at the graph. If performance and salary is in the category, then it is red. Similarly if one of them is low than it is gray colour.

[Fowmy]

@IF 

You can download the file: HERE

________________________

Did I answer your question? Mark this post as a solution, this will help others!.

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

YouTube, LinkedIn

[IF]

Hi,

Thanks. would it be possible to show it in a chart. I want to show the values (salary and performance) in X and Y axis. Also when I hover on the ID, I want to see the salary and performance values in tooltip.

Regards,

[Fowmy]

@IF 

Not quite clear about your requirement.

________________________

Did I answer your question? Mark this post as a solution, this will help others!.

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

YouTube, LinkedIn

[IF]

Hi,

Instead of showing the values in the relevant categories, I want to show the ID numbers in a graph. For example;

It is more X and Y axis. I want to show the ID numbers under the relevant categories. When I use scatter chart, it doesn't categorize the salary or performance scale or I don't know how to do it. I hope it is clear now.

Regards,

[Fowmy]

@IF 

Hope you get the desired result as below:

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

[IF]

Hi,

It is exactly like that 🙂 , but I want to show it in a chart. Would it be possible? The only reason that I want it in chart is that when I hover on the ID, I want to see the name, surname, etc. information. It is easy to add it with chart, but maybe possible with matrix as well.

All the best

[Fowmy · Accepted solution]

@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

[IF]

Hi,

Thanks a lot. It is good to know the limits. btw, the tooltip doesn't show correctly when nothing is selected.

[amitchandak]

@IF , Not very clear . Try segmentation 

https://www.daxpatterns.com/dynamic-segmentation/
https://www.daxpatterns.com/static-segmentation/
https://www.poweredsolutions.co/2020/01/11/dax-vs-power-query-static-segmentation-in-power-bi-dax-po...
https://radacad.com/grouping-and-binning-step-towards-better-data-visualization

and color measure with

https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-num...
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values

Colour = 
SWITCH(TRUE(),
Table[Date] < TODAY(), "red",
Table[Date] = TODAY(), "orange",
"green")

Color sales = if(AVERAGE(Sales[Sales Amount])<170,"green","red")
Color Year = if(FIRSTNONBLANK(Table[Year],2014) <=2016,"lightgreen",if(FIRSTNONBLANK(Table[Year],2014)>2018,"red","yellow"))

Color  = if(FIRSTNONBLANK(Table[Year],2014) <=2016 && AVERAGE(Sales[Sales Amount])<170 
,"lightgreen",if(FIRSTNONBLANK(Table[Year],2014)>2018,"red","yellow"))
Color sales = if([Sales Today] -[sales yesterday]>0,"green","red")

color =
switch ( true(),
FIRSTNONBLANK(Table[commodity],"NA") ="commodity1" && sum(Table[Value]) >500,"lightgreen",
FIRSTNONBLANK(Table[commodity],"NA") ="commodity2" && sum(Table[Value]) >1000,"lightgreen",
/// Add more conditions
"red"
)