Forum Discussion
Conditional formatting using percent option
Hi, I am unable to understand how the conditional formatting feature using percent option works.
I have this data set:
| Geo | Value |
| Global | 0 |
| Europe | 1.19 |
| United States | 2.14 |
and when I try to apply the following conditional formatting on it:
Only the "Global" value gets highlighted. From what I understood about this feature, both the "Global" and "Europe" values should be highlighted based on this rule, since my understanding is that the percent is calculated the following:
-First value is 0% (Global).
-To determine value for each remaining field, we take 100% and divide by the remaining fields (2 fields). This equals 50% per field.
-Then second value is 50%.
-Third value is 100%.
| Geo | Value | Percent |
| Global | 0 | 0.00% |
| Europe | 1.19 | 50.00% |
| United States | 2.14 | 100.00% |
Based on rule (0 <= Value < = 50%), both "Global" and "Europe" would be highlighted.
Microsoft has documentation here, but it's not clear.
Can someone please explain how does the percent feature work in conditional formatting?
4 Replies
- PadycosmosSolution Sage
Hope this helps:
- AnonymousNot applicable
Thanks, but this doesn't apply to my situation.
If you only have this
Geo Value Global 0 Europe 1.19 United States 2.14 and filter based on percent
How is that calculated in PBI? Why is 0 value for "Global" the only one highlighted?
- PadycosmosSolution Sage
Hope this helps:
- PadycosmosSolution Sage