PowerBI - [函数] concatenatex 用卡片图显示切片器选择的值

用卡片图显示切片器选择的值:
step1- 新建度量值Selected_Filter 

Selected_Filter = 
VAR selected_div1 = 
CONCATENATEX(VALUES('D_DIV '[Div]),'D_DIV'[Div],"/")
VAR selected_div2= 
CONCATENATEX(VALUES('OT.Div'[DIV]),'OT.Div'[DIV],"/") 
VAR selected_ym = 
CONCATENATEX(VALUES('T_Date.F'[YM]),'T_Date.F'[YM],"/") 
RETURN
IF(
ISFILTERED('OT.Div'[DIV]) || ISFILTERED('T_Date.F'[YM]),
"Filters:" & selected_ym &"/"& selected_div2, 
##也可以加换行符写成:
"Filters1:" & selected_ym & UNICHAR(10) & "Filters1:" & selected_div2,
"Filters:" & "ALL"
)

 Step2- 新建空度量值filter

filter = ""

Step3 - 新建卡片图,选择度量值Filter,在标题里面设置度量值 selected_filter  (如果加了换行符,要关掉 自动换行)

 

posted @ 2021-12-07 21:14  未必是小小  阅读(41)  评论(0)    收藏  举报