Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hi,
I have data like below in a table RunRate is a measure. I would like add folor color based on logic. Pls help me how can it be done.
idealRunrate : 33%
idealRate +/- 5% tollerance
IdealRate = 33+5 = 38% & 33-5 = 28%
Logic for font color - RunRate >= 28% && <=38% -> Green, Red
PRJOECTS | #Prj | Run Rate |
PRJOJECT1 | 18 | 34% |
PRJOJECT2 | 11 | 39% |
PRJOJECT3 | 12 | 27% |
PRJOJECT4 | 8 | 33% |
PRJOJECT5 | 9 | 36% |
PRJOJECT6 | 4 | 34% |
PRJOJECT7 | 25 | 36% |
PRJOJECT8 | 12 | 34% |
PRJOJECT9 | 13 | 36% |
PRJOJECT10 | 9 | 43% |
PRJOJECT11 | 8 | 46% |
PRJOJECT12 | 4 | 32% |
PRJOJECT13 | 0% |
Solved! Go to Solution.
Hi @manojk_pbi ,
Here are the steps you can follow:
1. Create measure.
Color =
var _idealRunrate=0.33
var _addidealRate=0.38
var _idealdecrease=0.28
return
IF(
MAX('Table'[RunRate]) >= _idealdecrease&&MAX('Table'[RunRate])<=_addidealRate,
"Green","Red")
2. Conditonal formatting – Background color.
3. Background color – RunRate.
Format style – Field value/
What filed should we base this on – [color]
4. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Step 1: - Right click on the measure/column for which you would like to apply
the formatting rule
Step 2: - In our scenario, we need to apply a conditional
formatting on Font color which can be selected by right clicking on the conditional
formatting option: -
Step 3: - Apply the below logic and click on OK.
Output : -
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @manojk_pbi ,
Here are the steps you can follow:
1. Create measure.
Color =
var _idealRunrate=0.33
var _addidealRate=0.38
var _idealdecrease=0.28
return
IF(
MAX('Table'[RunRate]) >= _idealdecrease&&MAX('Table'[RunRate])<=_addidealRate,
"Green","Red")
2. Conditonal formatting – Background color.
3. Background color – RunRate.
Format style – Field value/
What filed should we base this on – [color]
4. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi,
Please follow the steps here:
Apply conditional table formatting in Power BI - Power BI | Microsoft Learn
Opt for the Rules under Fotmat Style and select RunRate and the apply the condition & colors accordingly.
If need any other help, let me know.
Proud to be a Super User! | |
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
3 | |
2 | |
1 | |
1 | |
1 |