Solved: Conditional formating

stribor45 · ‎11-05-2023

I am having trouble getting the negative percentage to show as a red arrow. conditional formatting doesn't allow me to enter negative numbers. Any ideas on how to fix this? For example, -23.66 % should not be showing as going upward direction. Basically, anything that is in minus should be showing red.

pmreis · ‎11-05-2023

Hi @stribor45

You can create a DAX Measure for the arrow symbol, and another for the color according to the value.
Here is an example of how to do it: Adding Up and Down Arrows with Color to KPIs in Power BI - The Data School Down Under

Also, this post might help: Solved: Add colored KPI arrows to show the trend - Microsoft Fabric Community

Pedro Reis - Data Platform MVP / MCT
Making Power BI and Fabric Simple

If my response resolved your issue, please mark it as a solution to help others find it. If you found it helpful, please consider giving it a kudos. Your feedback is highly appreciated!

Find me at LinkedIn

View solution in original post

pmreis · ‎11-05-2023

Hi @stribor45

You can create a DAX Measure for the arrow symbol, and another for the color according to the value.
Here is an example of how to do it: Adding Up and Down Arrows with Color to KPIs in Power BI - The Data School Down Under

Also, this post might help: Solved: Add colored KPI arrows to show the trend - Microsoft Fabric Community

Pedro Reis - Data Platform MVP / MCT
Making Power BI and Fabric Simple

If my response resolved your issue, please mark it as a solution to help others find it. If you found it helpful, please consider giving it a kudos. Your feedback is highly appreciated!

Find me at LinkedIn