Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Change scatter plot - categorical count change

When trying to recreate below change scatter plot in Power Bi using the scatter chart I can't seem to figure out how to add the same categories in the y axis to compare the movements between categories between two points in time.

 

Basically the chart should show the count of lines in the dataset within category x axis that 'moved' to or remained in same category at another point in time being represented by the y axis. Both datapoints are included in the same dataset.

  

Need Help

5 Replies

  • v-jingzhang's avatar
    v-jingzhang
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi Anonymous 

     

    Can you provide some sample data without sensitive data? The X and Y axis fields should be the same column in a table and be non-aggregated, right? And the value should be count of rows that match the X-Y pairs?

     

    Best Regards,
    Community Support Team _ Jing

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi v-jingzhang ,

       

      A simple dataset and desired result in Power Bi would be as follows in which x axis is then 'Status_0' and y axis 'Status_1':

       

      ParticipantStatus_0Status_1
      A13
      B23
      C11
      D32
      E12

       

       

       

      • v-jingzhang's avatar
        v-jingzhang
        Icon for Community Support rankCommunity Support
        4 years ago

        Hi Anonymous 

         

        Select Don't summarize for both Status_0 and Status_1. Put Participant into Size well and select Count for it. You can change the marker size and axis range in Format pane.

         

        Best Regards,
        Community Support Team _ Jing
        If this post helps, please Accept it as Solution to help other members find it.