Forum Discussion

Mokegubshook's avatar
Mokegubshook
Helper I
1 year ago
Solved

Scatter Plot by each dot with each extraction

Hi, I can not find a way to make each dot in scatter plot to be separated by extraction. My desire is I want each dot to be separated by extraction, but each dot sum by day. Any way I can add each dot to be by an extraction?  

 

This is my scatter plot. 

X Axis: Date

Y Axis: Sum of RIC

Legend: Company 

Size: Sum of RIC

 

  • v-achippa's avatar
    v-achippa
    1 year ago

    Hi Mokegubshook,

     

    If you would like each dot to represent a different extraction while still coloring only by company, please follow below approach:

    Create a new calculated column:

    Date_Extraction = [Date] & " - " & [Extraction]

    Then use this Date_Extraction column on the x-axis instead of plain date. This ensures that each extraction appears as a separate dot per day.

     

    If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

     

    Thanks and regards,

    Anjan Kumar Chippa

6 Replies

  • v-achippa's avatar
    v-achippa
    Community Support
    1 year ago

    Hi Mokegubshook,

     

    Thank you for reaching out to Microsoft Fabric Community.

     

    To make each dot in the scatter plot to be separated by extraction still summing the RIC values by day, please follow below steps:

    • Confirm that your dataset has a column for extraction, this will be used to differentiate the dots.
    • Since the scatter plot’s legend can only use one field, so combine Company and Extraction fields into a new field. Create a new calculated column for example like below:
      Company_Extraction = [Company] & " - " & [Extraction]
    • In the Fields pane replace the Legend field with Company_Extraction field and keep the other feilds as they are.

    This makes that each dot will be separated by extraction, while still summing RIC values by day.

     

     

    If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

     

    Thanks and regards,

    Anjan Kumar Chippa

  • Mokegubshook's avatar
    Mokegubshook
    Helper I
    1 year ago

    Hi, thank you for your answering !

     

    I follow your step. It is not what I want. It is colored by Company - Extraction ID. Which is too many color.

    Is it possiple to done by just color by company ?

    • v-achippa's avatar
      v-achippa
      Community Support
      1 year ago

      Hi Mokegubshook,

       

      If you would like each dot to represent a different extraction while still coloring only by company, please follow below approach:

      Create a new calculated column:

      Date_Extraction = [Date] & " - " & [Extraction]

      Then use this Date_Extraction column on the x-axis instead of plain date. This ensures that each extraction appears as a separate dot per day.

       

      If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

       

      Thanks and regards,

      Anjan Kumar Chippa

      • v-achippa's avatar
        v-achippa
        Community Support
        1 year ago

        Hi Mokegubshook,

         

        As we haven’t heard back from you, we wanted to kindly follow up to check if the solution I have provided for the issue worked? or let us know if you need any further assistance.
        If my response addressed, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

         

        Thanks and regards,

        Anjan Kumar Chippa