Forum Discussion
Compare line chart
- 9 years ago
Hi, review this PBIX. Let me know if that is what you want.
https://drive.google.com/file/d/0B95C8CKdTZE3YjNzaVl4c0ZzeGM/view?usp=sharing
Many thanks for your help Angelia. v-huizhn-msft
I manage to make all you said, in a different excel of what I am attaching here, but as I need to make it work with only 3 columns, since the Postgresql only have this 3 columns, I attached here the correct XLS.
For example, we have 4 days of production, in each day the system will register any error ocurring, and time of the error.
So the final target of this line chart, is to compare in real time every day, so if I compare 4 days, it has to be drawed 4 lines, into the chart.
In that example, Imagine, AXIS X is time, so 8:30 , 9:30 ,10:30 ,11:30, 12:30, 13:30, 14:30 , etc..... usually from 8:30 till 17:30. Just that, no scroll bar needed.
AXIS Y, quantity of event, in this case the line of each day has to be accumulative, as you can see in the example chart.
And, COLOR LINES, each color is a day, for example, RED; 06/04/2017, GREEN; 07/04/2017, BLUE; 10/04/2017, etc...
So we can check in real time how is it going the production of today compare to another days.
EXCEL SAMPLE and PBIX:
https:// mega.nz/fm/8r4mEQLa
http:// www100.zippyshare.com/v/slsMnMDy/file.html
https:// ufile.io/06862
(remove space)
Many thanks!!!
Hi, review this PBIX. Let me know if that is what you want.
https://drive.google.com/file/d/0B95C8CKdTZE3YjNzaVl4c0ZzeGM/view?usp=sharing
- bannedillo9 years agoFrequent Visitor