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.

     

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

Mokegubshook's avatar
Mokegubshook
Icon for Helper I rankHelper 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.