英文:
Isolate one sheet from global filter
问题
我目前对Power BI并不太熟悉，但在处理一个现有的销售报告时，我遇到了一个问题。
基本上，我想要从已应用的全局筛选中分离出单个工作表，而无需将其从每个工作表中独立移除并重新应用，因为这将使用户感到繁琐。
在查看了StackOverflow上的一些其他帖子后，我发现了“修改交互”选项在“格式”部分，但却无法使其分离整个页面或者逐个分离可视化效果。
我尚未找到答案，因此我甚至不确定这是否可能。
有人知道如何做到这一点吗，或者这是否可能？
非常感谢！
英文:
I am not very experienced on Power BI yet and I am currently facing an issue while working on an existing Sales report.
Basically, I want to isolate a single sheet from an already applied global filter without having to remove it and reapply it independently on each sheet, as it would make it tedious for the user.
After looking at some other posts on StackOverflow I found the 'modify interactions' option in the Format section but couldn't manager to make it isolate either the whole page from the global filters or even the visuals one at a time.
I haven't been able to find an answer to this question, hence why I am not even sure this is possible.
Does anyone know how to do this or if this is even possible ?
Thank you very much !
答案1
得分: 1
如果您有需要忽略筛选器的度量值，您可以重写该页面上的度量值以忽略它们。以下是一个示例：
团队数据：
我添加了一个筛选器，用于所有频道为Development - PowerBI的页面。卡片中的频道计数为1。
向报表添加另一个度量值，以忽略此筛选器：
所有活跃频道 =
CALCULATE (
SUM ( 'Teams usage summary'[活跃频道] ),
REMOVEFILTERS ( 'Teams usage summary'[团队名称] )
)
该卡片显示41，表示所有团队的所有频道的总计数：
请注意，如果在报表中包含了团队名称，则此方法将无效 - 它将仅显示已筛选的团队，但会显示所有频道的总计数，这不是我们在这种情况下想要的结果。希望这有所帮助。
英文:
If you have measures that need to ignore the filters, you can rewrite the measures on that page to ignore them. Here is an example:
Teams data:
I added a filter for all pages where the channel is Development - PowerBI. The channel count in the card is 1
Add another measure to the report which ignores this filter:
Active channels (all) =
CALCULATE (
SUM ( 'Teams usage summary'[Active channels] ),
REMOVEFILTERS ( 'Teams usage summary'[Team name] )
)
This card shows 41, the total count of all channels for all teams:
Please note that this will not work if I have team name in the report - it will show only the filtered team, but the total count of all channels, which is not what we want in this case. Hope this helps.
答案2
得分: 0
很抱歉，无法从全局筛选器中排除页面。
英文:
Unfortunately, excluding a page from the global filters is not possible.
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论