Forum Discussion
Create a simple hour vs time span graph with out aggregation
I have a spreadsheet which has two columns, which are time stamp and observation. Total 86400 records for each second. That means each second has its own observation like Drill, wash, Roll etc. like...
dsrikanth Create calculated column for HOUR and MINUTES using dax as below. Then use scatter chart with x-axis as hour, y-axis as minutes, timestamp column as Details and observation column as Values.
=HOUR(tableName[columnName])
=MINUTE(tableName[columnName])
ankitpatira The user would need to go to Desktop to follow your suggestion - correct? Not knowing the data source I am just wondering if going to Desktop is possible or can one do your suggestion within Service?