Forum Discussion
Sum Data after every 30mins
Hi ,
I've created Hour, Minute, and Date column.
I've also created a first/second half hour bucket column based on Minute column.
But the resulting sum of the data is the same value in all the 30mins intervals.
| DataTime | FLOW |
| 01/09/2017 00:00 | 2940761.6 |
| 01/09/2017 00:00 | 2940761.6 |
| 01/09/2017 00:00 | 2940761.6 |
| 01/09/2017 00:00 | 2940761.6 |
| 01/09/2017 00:00 | 2940761.6 |
| 01/09/2017 00:00 | 2940761.6 |
| 01/09/2017 00:00 | 2940761.6 |
| 01/09/2017 00:00 | 2940761.6 |
| 01/09/2017 00:00 | 2940761.6 |
| 01/09/2017 00:00 | 2940761.6 |
| 01/09/2017 00:00 | 2940761.6 |
| 01/09/2017 00:00 | 2940761.6 |
| 01/09/2017 00:00 | 2940761.6 |
| 01/09/2017 00:00 | 2940761.6 |
| 01/09/2017 00:00 | 2940761.6 |
| 01/09/2017 00:00 | 2940761.6 |
| 01/09/2017 00:00 | 2940761.6 |
| 01/09/2017 00:00 | 2940761.6 |
| 01/09/2017 00:00 | 2940761.6 |
| 01/09/2017 00:00 | 2940761.6 |
| 01/09/2017 00:00 | 2940761.6 |
| 01/09/2017 00:00 | 2940761.6 |
| 01/09/2017 00:00 | 2940761.6 |
| 01/09/2017 00:00 | 2940761.6 |
| 01/09/2017 00:00 | 2940761.6 |
I've sent the pbix file to your mail.
Many Thanks for your help
Microsoft EmployeeAnonymous
I don't find any issue in your .pbix, it shows same total under each "Half Hour" (Your Minute column is based on DateTimePrevious, not DateTime) which is correct.
Regards,
Hi,
As mentioned, I want my resulting data/chart to respond when i click a slicer in my visual.
I want to be able to click a slicer, select a day in my first graph(stacked column) and the second graph (Line Graph) with the 'Sum Data after every 30mins' responds appropriately to the particlar day selected.
The 'Half Hourly Total' is not reponding when a particular slicer is selected.
Please where can i send you the PBIX file??
See how I want my graph to display
Hi,
I have been looking around and still cant find any solution to 'Sum Data after every 30mins' and for it to respond to selected day