Strugging to find a solution for this problem i have. I have two staff groups with just the start time and end time of their shifts.
|1||A||8:00:00 AM||3:00:00 PM|
|2||A||9:00:00 AM||4:00:00 PM|
|3||A||10:00:00 AM||5:00:00 PM|
|4||A||9:30:00 AM||3:00:00 PM|
|5||B||7:00:00 AM||3:00:00 PM|
|6||B||9:00:00 AM||3:00:00 PM|
|7||B||9:00:00 AM||4:00:00 PM|
|8||B||9:30:00 AM||5:00:00 PM|
I want to display this in a multi line grpah with the sum total of the staff as the Y axis
How do i go about presenting this in a graph for my dashboard?
Any help would be greatly appreciated
Solved! Go to Solution.
The reason behind that could be that lines are overlapping, switch to clustered column chat to check if you see the values for each group.
Also if you just reply saying I cannot see the result it doesn't help in anyways to provide a further solution. You have to be more specific and provide more detail.
Read this post to get your answer quickly.
Yes your solution makes sense, however i cannot recreate the results in my Dashboard. Im not getting the second group in the line graph at all. I have three groups in my results but even if i add a filter for only two of them i still do not get the two lines on the line graph.
But quick question though. Would i need to have a relationship between the hours table and the original table, and if so what am i connecting the time table too? do i connect it to the start time or the end time ?
The X-axis is currently is showing a "Time" - did you want the Start Time or End Time of the Shift? Also, are you using a Time Table in your Dashboard? If not, I'd recommend using one such as below:
VAR HourTable = SELECTCOLUMNS(GENERATESERIES((0), (23)), "Hour", [Value])
VAR MinuteTable = SELECTCOLUMNS(GENERATESERIES((0), (59)), "Minute", [Value])
VAR SecondsTable = SELECTCOLUMNS(GENERATESERIES((0), (59)), "Second", [Value])
CROSSJOIN(HourTable, MinuteTable, SecondsTable),
"Time", TIME([Hour], [Minute], [Second])
The last question prior to putting together a solution is your reference to a "Sum Total of Staff" - is this a Sum Total of Staff as individual persons (i.e. by their UserID) or the Staff Group level (i.e. by their Group A or B)?
If I have posted a response that resolves your question, please accept it as a solution to formally close the post.
Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!
Want to connect? www.linkedin.com/in/theoconias
Thanks for the reply Theo,
The graph is to show the number of staff that a present at the times of the day so it wouldnt be based on the start time or end time as one of the other.
I would like to group it on the staff group to show how many of that staff group was present at any point in the day
Click here to read more about the December 2021 Updates!
Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.
Mark your calendars and join us for our next Power BI Dev Camp!