Forum Discussion
How to get Power Bi to recognize and plot multiple data points in the same time frame
Hello everyone, a little scary. I'm not a programmer, I am a guy who likes to use numbers to prove things and Power Bi seems to be that tool.
I am looking at metrics and I am trying to simply plot XX by Day. There are several issues.
Since this is a 24/7/365 operation, we run 2 12 hr shifts, so there are multiple shifts in a day (A,B or C,D), each shift is a day or night, Add to that each shift could make multiple widgets, meaning A could make 3 widgets in 12 hrs, where B could make two seperate runs of 4 widgets in 12 hrs.
Here is what 7 days of data would look like:
Because I am not aware of a way to plot individual points vs date, I get a bar chart that sums each day:
7 bars, shifts summed popped up, I was instead hoping to see 19 bars, that I can break out (Quarter Date, Week, ETC).
Is there a solution for this issue? Remember, I am not a programmer, so if there is a solution, I will have to be walked through the solution.
Thanks for your help in advance.
CincyKidd
Ok, almost there!
Lastly, my data is a running data set, meaning I started tracking on June 15th. I understand that I can use the Slicer function to brake the data into months, is there a way to see the data set in its entirity, right now it looks like it is limited to 30 days.
Thanks for all the help, much appreciated!
CincyKidd
10 Replies
Not quite sure why you'd like 19 lines, data in report usually gets aggreaged instead. However some trick with RANKX can help to get 19 lines instead of 7.
Check more details in the attached pbix.
If it solves your problem, please accept it as solution. For more questions, feel free to let me know.
Eric- Thanks for the help, it looks like this might be the trick I was looking for, I will test it out later today and give a report.
By the way, I asked for the split instead of sum so I can look at specific performance. Now I will have the ability to look at combined performance or look at individual.
More to come and thanks again.
CincyKidd
Ok, two things.
1) what is the significance of the "Index" column?
2) how would I go about putting in the "Rank" column? I see there is code associated with the column.
Thanks.
CincyKidd
