Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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
You should be able to create a calculated column like:
HoursAgo = DATEDIFF([Date],NOW()),HOUR)
Then filter your chart by this column.
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!.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
98 | |
97 | |
81 | |
77 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |