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 Everyone,
First time posting so go easy on me.
I am looking for a way to achieve the below result that Columns A+B+C+D=E
But if Column E is greater than 80% of Column F, it will be formatted Red.
Stored Red Apples | Stored Blue Apples | Shipped Red Apples | Shipped Blue Apples | Total Apples | Limit |
1 | 1 | 1 | 4 | 7 | 10 |
1 | 1 | 1 | 5 | 8 | 10 |
Hope this makes sense.....
Solved! Go to Solution.
Welcome.
Should really be in Desktop forum. (just advice)
You'll need to add the values of course (can do this in Power Query or DAX).
You need a column or measure to work out the percentage, then apply conditional formatting on the ApplesTotal value.
A couple of links:
https://radacad.com/show-me-the-biggest-number-conditional-formatting-in-power-bi
Hi @Cornwalls ,
As @HotChilli mentioned, you could try to use column or measure and set conditional formmating on it to achieve this goal.
You could refer to my sample for details.
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Cornwalls ,
As @HotChilli mentioned, you could try to use column or measure and set conditional formmating on it to achieve this goal.
You could refer to my sample for details.
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Welcome.
Should really be in Desktop forum. (just advice)
You'll need to add the values of course (can do this in Power Query or DAX).
You need a column or measure to work out the percentage, then apply conditional formatting on the ApplesTotal value.
A couple of links:
https://radacad.com/show-me-the-biggest-number-conditional-formatting-in-power-bi
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 |
---|---|
102 | |
53 | |
21 | |
13 | |
11 |