Forum Discussion

Mokegubshook's avatar
Mokegubshook
Helper I
10 months ago
Solved

Scatter Plot by Extraction in Power BI

Hi Community, I try to do this visual in Power BI but can not find ways. I want to do scater plot by Extraction_ID where each dot represent each Extraction_ID and If Extraction_ID has waiting_time > ...
Need Help
  • mickey64's avatar
    mickey64
    10 months ago

        I knew that it was not possible to set date and time on the X-axis of a scatter plot, so I set numbers representing date and time on the X-axis.
        This is not possible with a scatter plot, but I think it would be possible with a Line chart, so please see the explanation below.(^^)/

     

    Step 0: I use these data below.

     

    Step 1: I add 'Year' column , 'Month' column, 'Day' column and 'DateTime' column in Power Query Editor.

     

     

    Step 2: I make a Line chart.

     

    For your reference.

     

mickey64's avatar
mickey64
Super User
10 months ago

Step 0: I use this DATA below.

 

Step 1: I duplicate 'Date'-column and change type of this colum in Power Query Editor.

 

Step 2: I rename the duplicate column. ('Date - Copy' --> 'Date-Num')

 

Step 3: I add a 'Date-Time'-custom column below.

 

Step 4: I change type of 'Date-Time' column.

 

Step 5: I make a scatter chart below.

 

 

 

 

 

 

 

 

  • Mokegubshook's avatar
    Mokegubshook
    Helper I
    10 months ago

    Thank you for helping but, This is almost what I want. I want X-Axis as date. But the X-Axis can't be right? I want to see each waiting_time of Extraction_ID in each date/time.

    • v-menakakota's avatar
      v-menakakota
      Community Support
      10 months ago

      Hi Mokegubshook ,
      Thanks for reaching out to the Microsoft fabric community forum. 

       

      I would also take a moment to thank mickey64 , for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.

      Can you confirm if your current X-axis is just using the Date column? Or are you already trying a combined Date/Time column?

       

      Best Regards, 
      Community Support Team

      • Mokegubshook's avatar
        Mokegubshook
        Helper I
        10 months ago

        In my senario, It should be Date-Time. For example, If I selected Date = 01/Jan/2025 and Hour = 0. If should shows data since 00:00 till 01:00 by extraction like picture I provide above.

    • mickey64's avatar
      mickey64
      Super User
      10 months ago

          I knew that it was not possible to set date and time on the X-axis of a scatter plot, so I set numbers representing date and time on the X-axis.
          This is not possible with a scatter plot, but I think it would be possible with a Line chart, so please see the explanation below.(^^)/

       

      Step 0: I use these data below.

       

      Step 1: I add 'Year' column , 'Month' column, 'Day' column and 'DateTime' column in Power Query Editor.

       

       

      Step 2: I make a Line chart.

       

      For your reference.

       

      • Mokegubshook's avatar
        Mokegubshook
        Helper I
        10 months ago

        Hi, Thank you so much. I really appreciate your work!