topic Show Last 24 Hours in a clustered column chart in DAX Commands and Tips

Show Last 24 Hours in a clustered column chart

v_mark — Fri, 19 Feb 2021 22:40:11 GMT

I was trying to create a measurement that will show the total crimes in the last 24 hours on a chart.
This Hour and Last Hour works fine. But the Last 24 is not. Seems like it will no go through the entire Last 24 hours from Now()

Not sure if I need to use another visual to show it or probably just have it on a table/matrix and drag the dates in just to show
those affected dates/data

I have this calc column in my time table

Last 24 Hours =

var _now = TIME(HOUR(NOW()), MINUTE(NOW()), SECOND(NOW()))

RETURN

if (DATEDIFF(_NOW, 'Time'[TimeandDay], HOUR) in GENERATESERIES(-23, 0, 1), 1, 0)

Any help would be greatly appreciated.

Here is the Power BI File that I am working with. Sample Data

Re: Show Last 24 Hours in a clustered column chart

rfigtree — Sat, 20 Feb 2021 01:42:20 GMT

i might be completely off base but would this work.

= var HrsDelta = 24 *( NOW() - Table1[dateTime] ) return if( HrsDelta <= 24 && HrsDelta >= 0, TRUE(), FALSE())

Re: Show Last 24 Hours in a clustered column chart

jameszhang0805 — Sat, 20 Feb 2021 02:30:04 GMT

I wonder if this is the reason, it seems like you made a minor mistake in your measure. If change this place to
"Last 24 Hours", the chart worked