Forum Discussion

Aish1992's avatar
Aish1992
Frequent Visitor
8 years ago
Solved

Is there a way to devise this visualization?

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 var...
v-piga-msft's avatar
v-piga-msft
Resident Rockstar
8 years ago

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's avatar
Aish1992
Frequent Visitor
8 years ago

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's avatar
    v-piga-msft
    Resident Rockstar
    8 years ago

    Hi Aish1992,

     

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

     

    Best  Regards,

    Cherry

    • Aish1992's avatar
      Aish1992
      Frequent Visitor
      8 years ago

      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's avatar
        v-piga-msft
        Resident Rockstar
        8 years ago

        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