Traffic Light Excel.xlsx (17.1 KB)
Traffic Light_pbix.pbix (537.3 KB)
Hi Experts
I need some help with conditional formatting traffic light icons on profit and loss budget variance. I have attached the excel where the calculation is done and traffic lights are working. I want to implement the same in Power BI. I have attached the pbix file as well.
Traffic Lights icons will be based on 5 variables.
- Variance with no budget
- More than $10,000 absolute value
- More than 10% absolute value
- less than -10% for revenue or more than 10% for expenditure
- Underspent by more than % in Cell X6 (expenditure only).
Could someone please help me with this ?
Regards,
Rajkumar
