Forum Discussion

Mokegubshook's avatar
Mokegubshook
Icon for Helper I rankHelper 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 > 10 then color on that dot. My problem is, I can't find way to by Extraction_ID and color it with contional formatting on scatter plot.

 

My data looklike:

Extraction_ID | Date | Hour | Mins | Secs | Waiting_Time

00001           1-Jan-25      0     2        0            5

00002           1-Jan-25      0     5        5            10

00003           1-Jan-25      1     1        20          50

00004           1-Jan-25      1     1        30           0

00005           1-Jan-25      2     1        5             15

 

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.

     

8 Replies

    • Mokegubshook's avatar
      Mokegubshook
      Icon for Helper I rankHelper I
      10 months ago

      Unfortunately, I can't attach files to comment due to company policy. If you can copy data from the post it would be good. I copy from real data. Thank you anyway.

  • mickey64's avatar
    mickey64
    Icon for Super User rankSuper 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
      Icon for Helper I rankHelper 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
        Icon for Community Support rankCommunity 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