Power plantform

Power BI- 弹窗预警

2022-10-19  本文已影响0人  yangBiBi
效果 - 关键指标预警提示框

新建度量值,主要分四步

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

上一篇 下一篇

猜你喜欢

热点阅读