效果 - 关键指标预警提示框
新建度量值，主要分四步
Alerts =
// UNICHAR(10) &
"营业额完成率 :" & UNICHAR(10) &
-- Notification Values
VAR _ValueTAR = FORMAT( [营业额完成率%],"+0%;-0%" )
-- Show Notificatins YES/No
VAR _ShowTAR = ABS( [营业额完成率%]) < 0.7
-- Notification Messages
VAR _MsgTAR = "TAR " & _ValueTAR
VAR _Notification =
IF( _ShowTAR, " • " & _MsgTAR & UNICHAR(10))
RETURN
_Notification
& UNICHAR(10) &
"主营业务收入 :" & UNICHAR(10) &
CONCATENATEX(
ALLSELECTED( 'Dim-门店编号'[门店]),
-- Notification Values
VAR _ValueSalesGrowthMOM = FORMAT( [主营业务收入MOM%],"+0%;-0%" )
VAR _ValueSalesGrowthYOY = FORMAT( [主营业务收入YOY%],"+0%;-0%" )
-- Show Notificatins YES/No
VAR _ShowSalesGrowthMOM = ABS( [主营业务收入MOM%]) > 0.5 && ABS( [主营业务收入MOM%]) <> 1
VAR _ShowSalesGrowthYOY = ABS( [主营业务收入YOY%]) > 0.8 && ABS( [主营业务收入YOY%]) <> 1
-- Notification Messages
VAR _MsgSalesGrowthMOM = 'Dim-门店编号'[门店] & "Sale MOM " & _ValueSalesGrowthMOM
VAR _MsgSalesGrowthYOY = 'Dim-门店编号'[门店] & "Sale YOY " & _ValueSalesGrowthYOY
-- Combined Notification
VAR _Notification =
IF( _ShowSalesGrowthMOM, " • " & _MsgSalesGrowthMOM & UNICHAR(10))
& IF( _ShowSalesGrowthYOY, " • " & _MsgSalesGrowthYOY & UNICHAR(10))
RETURN
_Notification
)
工具提示：图片不能设置工具提示框，用其他控件把字体设置为透明
设置字体颜色
Transparent = "rgba(0,0,0,0)"
方案来源 youtube：How to PowerBI
