cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper III
Helper III

Results against Date Graph (Scatter or Line)

Hi,

I recently started working on a Power BI project assigned to me. Basically what I have to do is to plot results on the y-axis and date-time on the x-axis. However, I have been having trouble doing so. When I plot a line graph, the 'Don't Summarize' option did not appear and when I plot the scatter chart, Power BI tells me that my x and y-axis values aren't playing together nicely. The data I am using is one I have pulled from ODBC and it looks something like this: 

 

ProductTypeMinimumMaximumResultDate
A1<=5 31/11/2019 3:19:20 PM
A2>=8 101/11/2019 3:19:20 PM
A35971/11/2019 3:19:20 PM
A441072/11/2019 4:20:07 AM
B1<=5 22/11/2019 4:20:07 AM
B2>=8 9 2/11/2019 4:20:07 AM

 

I have thousands of rows similar to this. May I ask how should I go about plotting the raw data Results against Date-time? Any help would be fully appreciated. Thank you.

 

1 ACCEPTED SOLUTION
Super User II
Super User II

Hi @7ea8ea

The line chart is not meant to handle multiple datapoints on the Y-axis while on the same X-axis value. 

You can achieve this with a scatter chart but it requires you to use an idex column as a legend, meaning that every dot will have a different color by default:

image.png

Instead I would advice you to use the custom visual, "Dot Plot, by MAQ software". Here you wont have the same issue with colors:

image.png


Br,
J


Connect on LinkedIn

View solution in original post

5 REPLIES 5
Super User II
Super User II

Hi @7ea8ea

The line chart is not meant to handle multiple datapoints on the Y-axis while on the same X-axis value. 

You can achieve this with a scatter chart but it requires you to use an idex column as a legend, meaning that every dot will have a different color by default:

image.png

Instead I would advice you to use the custom visual, "Dot Plot, by MAQ software". Here you wont have the same issue with colors:

image.png


Br,
J


Connect on LinkedIn

View solution in original post

Hi J,

 

Is it possible to plot target lines in Dot Plot? I also want to plot the maximum and minimum lines for each type. Thank you

Hi J,

 

Thank you for the clarification. However, I see that the y-axis in your example is still in 'sum'. For my data, 'sum' would be undesirable as I do need the raw data to be plotted. However, when I do change 'sum' to 'Don't summarize', Power BI says that my x and y-axis don't play well together. Any idea how do I fix that? Thank you very much.

 

Best Regards,

T

The Y-axis / Value in the visuals will require an aggregation. To get around this you need to use an index or other unique identifier to seperate the datapoints. There will still be an aggregation, but the aggregation will only contain a single row of data meaning that you should always get the individual datapoint even if you're performing an aggregation. 

As to the target lines im not quite sure. I'm not too familiar with the visual from MAQ Software so i'm not sure if they offer the functionality. I can take a closer look later this week but I'm not too hopefull sadly! 

Br,
J


Connect on LinkedIn

Hi J,

 

Thanks for the help.

 

Best Regards,

T

Helpful resources

Announcements
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Microsoft Ignite

Microsoft Ignite with Arun Ulag

Featured Session Drive Data Culture with Power BI: Vision, Strategy & Roadmap. Register here https://myignite.microsoft.com #MSIgnite #PowerPlatform #Power BI ​

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors