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 (如果加了换行符,要关掉 自动换行)


浙公网安备 33010602011771号