英文:
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).
答案1
得分: 0
是的。创建一个度量，其公式为：
度量 = COUNTROWS(Tbl_Import)
将这个度量添加为可视筛选器到切片器，限制其显示计数 > 0。
英文:
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.
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论