Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
I need some help with conditional formatting on my report. I have 2 columns (Target & Actual - Data below) and wanted to add the following rules and give a RAG rating.
if actual is less <98% of target then Red
if actual is between 98%-99.99% of target the Amber
if actual is >=100% then Green
Can someone advise then best way of doing this please? I am new to Power BI and my knowledge is very limited at the moment so a step by step tutorial would be a great help.
Thanks
Abz
Solved! Go to Solution.
Hi @Abz_17
You can create this measure
and click on the "fx" to add that measure as field value in order to apply the specific colors
If this post helps, accept it as a solution
Hi @Abz_17
You can create this measure
and click on the "fx" to add that measure as field value in order to apply the specific colors
If this post helps, accept it as a solution
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
100 | |
80 | |
63 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |