Power Bi: 将切片器限制为存在于事实表中的值

huangapple go评论59阅读模式
英文:

Power Bi: limit slicer to values that exist in fact table

问题

I have 1 Fact Table Tbl_Import in my Pbix-file that is linked with an automatic generated calendartable.

我在我的Pbix文件中有一个事实表Tbl_Import,它与一个自动生成的日历表相关联。

I used a slicer and a table. The slicer is showing too much options. The first date in Tbl_Import is 16/12/2022, but in the slicer I have all the other months also.

我使用了一个切片器和一个表格。切片器显示了太多选项。Tbl_Import中的第一个日期是2022年12月16日,但在切片器中我也有所有其他月份的选项。

Is there a way to limit the slicer options to the actual dates in the facttable?

有没有办法将切片器选项限制为事实表中的实际日期?

I am using Power Bi Desktop (without Premium).

我正在使用Power Bi Desktop(没有高级版)。

英文:

I have 1 Fact Table Tbl_Import in my Pbix-file that is linked with an automatic generated calendartable.

I used a slicer and a table. The slicer is showing too much options. The first date in Tbl_Import is 16/12/2022, but in the slicer I have all the other months also.

Is there a way to limit the slicer options to the actual dates in the facttable?

I am using Power Bi Desktop (without Premium).

Power Bi: 将切片器限制为存在于事实表中的值

答案1

得分: 0

是的。创建一个度量,其公式为:

度量 = COUNTROWS(Tbl_Import)

将这个度量添加为可视筛选器到切片器,限制其显示计数 > 0。

Power Bi: 将切片器限制为存在于事实表中的值

英文:

Yes. Create a measure which is

Measure = COUNTROWS(Tbl_Import) 

Add the measure as a visual filter to the slicer with it restricted to showing a count > 0.

Power Bi: 将切片器限制为存在于事实表中的值

huangapple
  • 本文由 发表于 2023年2月8日 14:21:26
  • 转载请务必保留本文链接:https://go.coder-hub.com/75382019.html
匿名

发表评论

匿名网友

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

确定