Forum Discussion
Complete Newb question - line chart visual
I have a meter installed on a piece of pipe. I have the data from the meter readings on a monthly basis. For instance meter 1 read 1.003 in Jan, 0.9987 in Feb, 1.000 in march etc. I just want to plot the meter readings on the y-axis and the dates on the x-axis. Then, the meter should not read +/- 0.0025 from any of the previous reading months. I have the data clean and imported, just can't figure out a basic chart. Power BI is very confusing. It originally tried to sum my meter readings and took an hour to figure out how not to sum that column in the table. I essentially want a variance of no more than +/- 0.0025 from the previous months reading AND no more than +/- 0.0025 between any of the readings. I have been using BI for one day. Data from PQ.meter reading vs. date
6 Replies
- lbendlin
Super User
Please provide sanitized sample data that fully covers your issue. I cannot help you without meaningful sample data.
Please paste the data into a table in your post or use one of the file services like OneDrive or Google Drive. I cannot use screenshots of your source data.
Please show the expected outcome based on the sample data you provided. Screenshots of the expected outcome are ok.
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523Hi lbendlin, thanks for taking the time to help me. I am looking to plot on a line chart, the "closing date" on the x axis and "meter factor" on the y axis with some sort of visual on the graph when the meter factor, compared to the previous month or any other value in the previous months, present a variance of +/- 0.0025. I would do it for each "meter ID" (211,212,213,291). Since I'm so new, I can't say exactly what that visual would look like as I don't know what I don't know. A graph similar to below with maybe a dot red (instead of blue dot) when the variance is out +/- 0.0025. Ignore the red lines on the screenshot below
Data Table attached.
Thank you very much
- lbendlin
None of your meters seem to exceed the +/- 0.0025 threshold between readings. Please either provide different sample data or specify what your threshold criteria are.
