Bar chart time referance

[Noak]

Hi,

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.

thank you!.

looking for solution

[v-caliao-msft]

Hi @Noak,

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.

Regards,

Charlie Liao

[Greg_Deckler]

You should be able to create a calculated column like:

HoursAgo = DATEDIFF([Date],NOW()),HOUR)

Then filter your chart by this column.

[Noak]

Hi @Greg_Deckler @v-caliao-msft,

thank you for your help still having issues.

the PBI dont know to seperate different hourse at the same date.

lets say today 28/11 and yasterday was the 27/11 :

27/11 13:00 Hourse ago =24

27/11 12:00 Hourse ago =24

please via attached.

your help appriciated!.