Correlation

[scootzinc]

I have a table that essentially looks like this: 

SUPPLIER	CC#	Y/N
Supplier X	132-04-002	Y
Supplier W	132-03-001	N
Supplier W	132-04-007	Y
Supplier W	132-03-003	N
Supplier W	132-03-001	Y
Supplier X	132-04	Y
Supplier X	132-01-001	Y
Supplier W	132-02-001	Y
Supplier Y	132-03-001	N
Supplier X	132-04-005	Y
Supplier Y	132-04-007	N
Supplier X	132-04-005	N
Supplier Z	132-04-001	Y
Supplier W	132-01	N
Supplier Z	132-04-005	N
Supplier W	132-04-007	Y
Supplier W	132-03-003	N
Supplier Y	132-04-004	N
Supplier W	132-01-002	N
Supplier W	132-01-002	N
Supplier Z	132-01-003	Y
Supplier X	132-01-004	Y
Supplier Z	132-02-002	N
Supplier Y	132-01-003	Y
Supplier X	132-02	Y
Supplier X	132-04	N
Supplier Y	132-03-003	N

Essentially, I'd like to find a way to display the suppliers across the Y access, the CC# across the X access and only include the "y" values (which can be replaced by a number value if it makes displaying it easier). I'd like to have it feature something like the ribbon visualisation where it connects suppliers from x value to x value. In a correlation chart, this would like essentially be like a table where there is a color where there would be a "Y" value and nothing where there is a "N" value. The idea is to be able to easily identify where suppliers offer certain capabilities so that I can easily see where they overlap. Ideally, I'd add another column that indicates the amount of spend we have with a supplier in that capability. So that I can see where we might be able to consolidate spend and reduce our number of suppliers... Does that make sense?

[scootzinc]

Hi @v-henryk-mstf 

Thank you for your time and any assistance. Please see the above explanation. 

Thank you,

Marc

[scootzinc]

So, I've posted what I've been able to create here. Essentially, I'm trying to find a way to visualize where there is an opportunity to reduce the number of suppliers. The ribbon chart on the top shows where there is a "y" indicating that the supplier does provide that service. It connects with the chart on the bottom, which shows how much the company spends with each supplier for that "commodity code" (thanks Ariba)... I want to be able to easily identify where we can reduce our suppliers, by consolidating spend from, say for example, 4 suppliers to 2 suppliers. What I'd really like this to do, if it could, is identify where, across a group of commodity codes, there is at least 1 supplier who supplies all commodity codes (capabilities), but where there is spend with greater than 1 supplier. In the case of the data provided in the attached image, Supplier W, in light blue, would be the best option for consolidating all spending. Supplier Z might be the best option for reduction (getting rid of this supplier to reduce the number of suppliers we contract with...). Does that make more sense? If so, I wasn't sure if there was a better way to create that visualization so that it's easier to identify opportunities. 

[v-henryk-mstf]

Hi @scootzinc ,

It is not quite clear what you are looking for, is it possible to further describe your business needs and provide information such as screenshots of the desired results.

How to Get Your Question Answered Quickly - Microsoft Power BI Community

Looking forward to your reply.

Best Regards,
Henry