Power KPI indicator Index

Hi all, I wanna create a conditional formatting where by if KPI status <95% shows a red arrow down, 95%- 100% a green check mark and > 100% shows arrow up. Can anyone help create this measure fo...

Need Help

Tips and Tricks

Tutorial Requests

v-yueyunzh-msft
3 years ago
Hi Yuiitsu

According to your current demand description, I can clearly understand your needs, you need measure to count if margin <95% =1, 95%- 100% =2, > 100% =3 in my data, You can use the Switch function in DAX to create the following metric value:

Arrow = SWITCH( TRUE(), [BU Margin]>=0&&[BU Margin]<=0.95,1, [BU Margin]>0.95&&[BU Margin]<=1,2, [BU Margin]>1,3)

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI!

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly