在 PowerBI 报告中排除周末? [英] Exclude weekends in PowerBI report?

问题描述

我有一个 Power BI 中的 VS Team Services 项目的燃尽图 - 这样我们就可以报告故事点而不是剩余的工作量.

I have a burn down chart for our VS Team Services project in Power BI - so that we can report on story points and not effort remaining.

在图表中，我在 X 轴上有日期.有没有办法从图表中过滤掉周末日期?周末没有活动.

In the chart, I have Date on the X axis. Is there a way to filter out weekend dates from the chart? There is no activity on the weekend.

我发现这个论坛帖子，但是我不明白如何将其添加到我们的报告中.

I found this forum post, however I didn't understand how to add this to our report.

推荐答案

你的数据集中有星期几"列吗?如果是，那么您可以简单地添加报告/页面级别过滤器并从报告中排除周六和周日...

Do you have 'day of week' column in your dataset ? If yes, then you can simply add a Report / Page level filter and exclude Saturday and Sunday from the Report...

这篇关于在 PowerBI 报告中排除周末?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！