Forum Discussion
Exclude data from the current hour
Hi how would I exclude data being shown from the last hour?
I can't see any option in the filters so assume it would have to be within the query?
Hi , JH25
According to your description, you want to Exclude data from the current hour.
If you want to directly delete the data from the current hour, you need to filter the data just in Power Query Editor.
If you want to exclude the data in the visual , you can use the "Filter on this visual" feature to realize the need.You can put the Date/Time column to it and configure it according to your logic.
For more information, you can refer to :
Add a filter to a report in Power BI - Power BI | Microsoft LearnThank you for your time and sharing, and thank you for your support and understanding of PowerBI!
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
1 Reply
Hi , JH25
According to your description, you want to Exclude data from the current hour.
If you want to directly delete the data from the current hour, you need to filter the data just in Power Query Editor.
If you want to exclude the data in the visual , you can use the "Filter on this visual" feature to realize the need.You can put the Date/Time column to it and configure it according to your logic.
For more information, you can refer to :
Add a filter to a report in Power BI - Power BI | Microsoft LearnThank you for your time and sharing, and thank you for your support and understanding of PowerBI!
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly