powerbi - Published Report behaves differently than Power BI Desktop

Question

I have the below tab in a report that contains 5 visualizations and a table. Filtering between them works just fine in Desktop.

After publishing the report to the Power BI service, it looks like this. Refreshing has no effect.

I have tried duplicating the tab and also re-created it completly and the same occurs.

Any suggestions to resolve this is appreciated. BTY, all the other tabs in the report work perfectly after publishing. It is just this one that is problematic.

Thanks in advance.

标签： powerbi

Answer 1

我发现了原因，这可能是一个错误。

选项卡上的可视化依赖于筛选的字段名称 MailboxExistsFlag，该字段名称为真或假。在 Desktop 中，过滤器如下所示：

当 pbix 文件发布时，相同的过滤器会转换为这个，这是不同的：

为了解决这个问题，我编辑了在线版本中的每个过滤器，并选择了“-1”来代替 TRUE。这样做之后，所有的可视化都可以正常工作。如果我对报告进行更改并再次发布，我希望我必须对页面执行此操作。

为什么 TRUE/FALSE 在网上变成 -1/0 让我无法理解，但要注意是否有包含此类列的报告。