topic One Column, Many Variables - how to create a scatterplot in Custom Visuals Development Discussion

One Column, Many Variables - how to create a scatterplot

segranp — Fri, 05 Apr 2019 07:07:36 GMT

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

Re: One Column, Many Variables - how to create a scatterplot

v-evelk — Mon, 08 Apr 2019 11:32:46 GMT

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