scatter chart with grouped values in x/y axes

[IF]

Hi,

I want to add categories to the X and Y axes at the scatter chart. Is it possible to add such grouping?

If the salary is >18500 high, between 18499 and 16000 "medium", <15999 "low". Similarly if performance is >50 "low", between 51 and 80 "normal", <81 "high". I want to show these categories at the chart. I have about 5000 values in the chart.

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

Thanks in advance!

[v-lionel-msft · Accepted solution]

Hi @IF ,

I'm not sure if there is such a custom visual, I suggest you do like this.

Best regards,
Lionel Chen

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

[IF]

I think you mean to have a new column and use switch prompt to have  the categories and put it to the legend. I have 5 categories for salary and 5 categories for performance. in this case I will have 25 items in the chart. It looks like this is the only way since I can not add another category to the axes. Thanks for the support. 

[amitchandak]

@IF , You can add only on the x-axis. Not on the y-axis.  You can check for custom visual https://appsource.microsoft.com/en-us/marketplace/apps?product=power-bi-visuals

Another Idea is in place of the range have min or max of range as the number and use that

[IF]

Hi,

I couldn't find any certified visual and I don't know how to use range either. If you could share me the example, I would accept the solution.

Regards,