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 > ...
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
Icon for Super User rankSuper 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
Icon for Helper I rankHelper I
10 months ago

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