Is there a way to devise this visualization?

[Aish1992]

Hi everyone

I tried to create a visualization similar to the below attached sample visualization using scatter plot but have been unable to do so because scatter plots don't allow categorical variables. Is there any way to devise this visualization in Power BI? 

 

[v-piga-msft]

Hi @Aish1992,

From the output you desired, it seems that the value in X axis is text value. 

Actually, we use scatter chart to show the value to plot two groups of numbers as one series of xy coordinates in Power BI.

So the value for X axis should be a numberic value.

For reference, you could have a good look at When to use a scatter chart or bubble chart.

Best Regards,

Cherry

[Aish1992]

Thanks for the responnse @v-piga-msft. I understand that only numeric variables can be represented on the x-y axis of the scatter plot but the task at hand requires me to represent a categorical variable on the x-axis.

Any other way to do so by using any other chart, etc? 

[v-piga-msft · Accepted solution]

Hi @Aish1992,

You could have a try with the custom visual Dot Plot by OKViz.

Best  Regards,

Cherry

[Aish1992]

Thanks for the suggestion. It works fine for now but would've been perfect, if the bubble/dot size fluctuated on the basis of some passed parameter. (Impressions in my case)

Great work @v-piga-msft !

[v-piga-msft]

Hi @Aish1992,

If your problem have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

Best Regards,

Cherry