Forum Discussion
Scatter chart with hours as Y axis
- 8 years ago
HI, carlosflores
For the values on the Y-axis have to be aggregated, you need to add a "type" for your basic data to classify these Time.
for example:
assume that:
A representative When they get in.
B representative When they go to lunch
C representative When they come back from lunch
D representative When they leave for the day.
then drag the field type into Legend values
Result:
here is pbix, please try it.
https://www.dropbox.com/s/9rm7g2gpsivty6p/Scatter%20chart%20with%20hours%20as%20Y%20axis02.pbix?dl=0
Best Regards,
Lin
HI, carlosflores
For the values on the Y-axis have to be aggregated, you need to add a "type" for your basic data to classify these Time.
for example:
assume that:
A representative When they get in.
B representative When they go to lunch
C representative When they come back from lunch
D representative When they leave for the day.
then drag the field type into Legend values
Result:
here is pbix, please try it.
https://www.dropbox.com/s/9rm7g2gpsivty6p/Scatter%20chart%20with%20hours%20as%20Y%20axis02.pbix?dl=0
Best Regards,
Lin
v-lili6-msft YES! thank you, it works :')