Color Coding Based on KPI Threshold

[puru85]

Hi Experts,

I need assistance with incorporating color-coded font for Sales KPI based on targets met in my Power BI report.

Here are the details:

1. Sales Target Calculation:

   • The target for sales every month is $50,000 plus an additional 20%.
   • The specific sales target formula is: (50,000 / number of workdays) + 20%
     
     

2. Workdays Calculation:

   • Workdays are calculated as the number of days per month minus public holidays, Saturdays, and Wednesdays. If a public holiday falls on a Wednesday, it should be additionally subtracted.
   • A Public Holiday Table exists in the data model to assist with this calculation.
     
     

3. Color Coding Based on KPI Threshold:

   • I want to apply the following font color coding based on the percentage of the target met:
     • 100% or above: Green
     • Greater than 90% but less than 99%: Blue
     • Greater than 80% but less than 90%: Orange
       
     • Below 80%: Grey
       

I have attached my PBIX file for reference. Any guidance on how to implement this in Power BI would be greatly appreciated.

Color Coding Based on KPI Threshold.pbix

Thank you for your help!

[miTutorials]

Check out the below tutorial - hope this helps !

New Feature in PowerBI lets you format labels conditionally | MiTutorials (youtube.com)