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 Folks, I am trying to create a graph of Transaction Count per 15min time interval for the last 6 hours of transactions. The intention is that this graph will be on a dashboard to make use of the push dataset auto updating feature
I am trying to run this on a Push Dataset table that includes the following fields
Graphing [Created Date] vs COUNT([Transaction ID] gets me some of the way there but have two issues
This seems like it would be a standard graph for push (and streaming) datasets so I am hoping there is just some feature I am not seeing
Solved! Go to Solution.
Hi. I'm not sure about the first one but the second one is now release as preview in last weeks:
Please update your power bi desktop to work with that.
Before that update what you could have used was filtering your result by "CALCULATE ( [Measure], Table[DateColumna] > NOW() - 0,0104)"
That will take last 15 minutes for example.
Regards
Happy to help!
Hi. I'm not sure about the first one but the second one is now release as preview in last weeks:
Please update your power bi desktop to work with that.
Before that update what you could have used was filtering your result by "CALCULATE ( [Measure], Table[DateColumna] > NOW() - 0,0104)"
That will take last 15 minutes for example.
Regards
Happy to help!
It was fortutious that they released the relative time filter in the most recent update. Thanks for pointing it out that makes it a lot easier. The alternative way to do it seems considerably less flexiable
As for the first point I believe I can aggregate it into 15min slots at the source and add a new 'Date Created 15min timeslice' field. It is not very flexiable but can be workable
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.