Line value points for each Column series

[pablopablo]

Hi, I have the following graph which displays attendance by room for specific times of the day. The purple line with dots is the sum of the staff required for that day by time. Is there a way that I can have a dot for each room rather than just for the time slot?

Here is a sample of my data

So at the moment my graph would show (from this picture) would show a total of 37 staff (sum of calc_headcount)

what i want it to show is 

6:15am - 3

6:30am - 3

....

8:45am - 9 (3+3+3) for the 3 records at 8:45am

Is this possible? So essentially a dot above each coloured column

[amitchandak]

What is formula you are using for staff in chart visual

[pablopablo]

This is just a field in the data set with numbers.

So in the graph it is displayed as the line and it is using 'sum' to display the dots. So it is summing by time. Need it to some by room but still display the times along the x axis

[v-gizhi-msft · Accepted solution]

Hi,

According to your description, it think the line value in 'Line and cluster column chart' can not display by each 'Room' in this case.

But i have a workaround:

1)Create a new page as a tooltip:

2)when you hover on one dot in line chart, it shows:

Best Regards,

Giotto Zhi

[pablopablo]

Will give it a try.

Thank you for your help