currently Im working on big cloud project using your platform .
have some issues with the bar chart, my data includes:
X: Incoming message every 5 minutes .
y: AVG sum messages .
I would like to present msg only for past hour from NOW, and (if I can) to draw a line as shows in the image (I would like to emphesis "Current" time on the line chart)..
please help me.
You should be able to create a calculated column like:
HoursAgo = DATEDIFF([Date],NOW()),HOUR)
Then filter your chart by this column.
Proud to be a Datanaut!
Add a calculated colume by using the DAX below.
Type = IF(DATEDIFF(Sheet7[DateTime],NOW(),MINUTE)<=60,"Latest Data","History Data")
Then add this new created column to a slicer visual.