Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

Need help on finding a way to visualize this data

I have a table that essentially looks like this: 

Supplier X132-04-002Y
Supplier W132-03-001N
Supplier W132-04-007Y
Supplier W132-03-003N
Supplier W132-03-001Y
Supplier X132-04Y
Supplier X132-01-001Y
Supplier W132-02-001Y
Supplier Y132-03-001N
Supplier X132-04-005Y
Supplier Y132-04-007N
Supplier X132-04-005N
Supplier Z132-04-001Y
Supplier W132-01N
Supplier Z132-04-005N
Supplier W132-04-007Y
Supplier W132-03-003N
Supplier Y132-04-004N
Supplier W132-01-002N
Supplier W132-01-002N
Supplier Z132-01-003Y
Supplier X132-01-004Y
Supplier Z132-02-002N
Supplier Y132-01-003Y
Supplier X132-02Y
Supplier X132-04N
Supplier Y132-03-003N


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?


Helpful resources

Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors