cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Noak Member
Member

Bar chart time referance

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!.

 

 

 

 

CloudDash.pnglooking for solution

 

 

 

 

BR,
Noa.
3 REPLIES 3
Super User
Super User

Re: Bar chart time referance

You should be able to create a calculated column like:

 

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

Then filter your chart by this column.


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


Moderator v-caliao-msft
Moderator

Re: Bar chart time referance

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.

Capture.PNG

 

Regards,

Charlie Liao

Noak Member
Member

Re: Bar chart time referance

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!.

 

PBI help.png

BR,
Noa.