我要求切片器中选择的值必须有效.
让我们假设,如果我在商店切片器"中选择一个值,并且该商店被从公司中删除.切片器仍会显示其名称,而与切片器交互的视觉效果中没有数据.
已选择默认值
手动更新切片器值
但是我只希望在我的商店切片器中选择相关的商店.我知道它的切片器的属性可以保留在发布报表时在其中设置的值,但是有任何解决方法.
解决方案您的问题的实质已在以下线程中被询问并覆盖:
这是一个可供下载的示例文件(M和DAX中都有这两种方法):
M默认切片器值.pbix
您可以通过添加计算表来完全在DAX中创建DimStore表:
DimStore_DAX =SUMMARIZECOLUMNS(销售[商店],销售",[销售],排名",RANKX(全部(销售[商店],[销售]),"StoreName",如果IF(RANKX(ALL(Sales [Store]),[Sale])= 1,最大的商店",VALUES(Sales [Store])))I have a requirement that the selected value in slicer must be valid.
Let us suppose if I select a value in Store slicer and that store gets deleted from the company. The slicer will still show its name with no data in visuals interacting with the slicer.
Default Value Selected
Updated Slicer Value Manually
But I want only the relevant store selected in my Store slicer. I know its slicer's property to retain the value which is set in it while publishing the report, but is there any workaround for it.
解决方案The essence of your question has been asked and covered in this thread:
Initial value of Power BI slicer based on another slicer choice
The answer is NO, but I can propose a workaround.
Since there is always a store with the highest sales you may always have that value ticked in the slicer and it will always show data.
In this example "The biggest store" is "Store for girls". I keep it selected on the slicer. Then I remove all the records of that store from fact table. Apply. And the slicer is still selected as "The biggest store" but now the biggest store means "Store for ladybirds".
Here is a sample file for download (with both approaches in M and DAX):
M Default Slicer Value.pbix
You can make DimStore table completely in DAX by adding calculated table:
DimStore_DAX = SUMMARIZECOLUMNS ( Sales[Store], "Sales", [Sale], "Rank", RANKX ( ALL ( Sales[Store] ), [Sale] ), "StoreName", IF ( RANKX ( ALL ( Sales[Store] ), [Sale] ) = 1, "The biggest store", VALUES ( Sales[Store] ) ) )
更多推荐
如何在Power BI中将切片器值设置为第一个可用值形式表?
发布评论