One Column, Many Variables - how to create a scatterplot

[segranp]

Hi All

My data has as all variables (eg. revenue, costs, profit) in one column called Variables.

In another column, I have all the data called Data. 

In another column, I have the respective company names, called Company_Names.

I wish to create a scatterplot graph, Revenue on x-axis and Costs on y-axis, with Company_names show per data point.

How can I create this?

Thank you

[v-evelk]

Hi,

I see two ways to implement this:

1. Use DAX in Power BI Desktop to extract your data into several columns and then use Enhanced Scatter for visualization.

2. Fork Enhanced Scatter from public repository as basis for your own custom visual and modify it. In this case you will probably need to use Matrix or Table mapping instead of Categorical and manage data inside the code.

Kind Regards,

Evgenii Elkin,
Software Engineer
Microsoft Power BI Custom Visuals
pbicvsupport@microsoft.com