Hit rate on bubble chart

[vcarissimo]

Hi There,

This is my first message so I hope I am at the right place. I'm a super beginner at Power BI so I'm looking for a bit of support.

I've got data on bids (win and lost) and I've got two segments where I'd like to analyze the hit/rate of my company.

1st segment is the type of product A, B, C,... (Info in one column)

2nd segment  is the type of customer 1, 2, 3, 4

An the last info is the number of articles per bids

My excel spreadsheet has more than 1000 lines and each line is a bid with a number of articles, customer type and type of product.

I would like to create a buble chart where I can have on the X axis my customers and Y axis my products. Inside the chart I'd like to see my hit rate (units won / (units won + units lost)) but also the size of the market (reason for using bubble chart). The purpose is to identify our sweet spots and the market size associated to them.

Data avaialable:

Column A Customer

Column B product

Column C number of products in the bid

Column D offer lost/offer won

Thank you very much for the champions who will be able to assist me. 

[David-Ganor · Accepted solution]

Hi, 

Scatter plot and bubble chart are used where X and Y axis are numerical values.

I think more appropriate for your situation is some kind of hitmap.

I suggest you to use a matrix visual:

Rows - customer

Columns - products

Values - hit rate

Afterwards - apply conditional formatting:

Background - by hit rate

Font - by market size.

Hope it helps

David

[vcarissimo]

Hi David,

Thanks for your advice, I will see what I can do with Matric Visual.

Have a good day.