Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
I am trying to visualize Jobs Running each day using running total so that it can aggregate all values according to time it get completed on that particular day. However for Today and previous days it is working fine and aggregating the value as required except yesterday.
For yesterday date it is not aggregating the value according the time.
I have use this measure to visualize running total:
Finished running total in START_DATE =
CALCULATE(
SUM('Query1'[Finished]),
FILTER(
ALLSELECTED('Query1'[START_DATE]),
ISONORAFTER('Query1'[START_DATE], MAX('Query1'[START_DATE]), DESC)
)
)
Visual for Today Running Total:
Visual for Yesterday:
For Previous Days:
Would request you to please suggest the changes to get the correct visual of yesterday data .
Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.
https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
Check out the February 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 3 | |
| 2 | |
| 2 | |
| 1 | |
| 1 |
| User | Count |
|---|---|
| 3 | |
| 3 | |
| 2 | |
| 2 | |
| 2 |