Forum Discussion
Conditional formatting with multiple column/bar values
Hi Anonymous ,
There are a few considerations to keep in mind when working with conditional table formatting:
- Conditional formatting applies only to the values of Table or Matrix visuals, and doesn't apply to any subtotals, grand totals, or the Total row.
- Any table that doesn't have a grouping is displayed as a single row that doesn't support conditional formatting.
- You can't apply gradient formatting with automatic maximum/minimum values, or rule-based formatting with percentage rules, if your data contains NaN values. NaN means "Not a number," most commonly caused by a divide by zero error. You can use the DIVIDE() DAX function to avoid these errors.
- Conditional formatting needs an aggregation or measure to be applied to the value. That's why you see 'First' or 'Last' in the Color by value example. If you're building your report against an Analysis Service multidimensional cube, you won't be able to use an attribute for conditional formatting unless the cube owner has built a measure that provides the value.
Reference: Use conditional formatting in tables
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous,
In summary, if I have understood correctly, my problem is that I have multiple data represented in the same visual and conditional formatting is only supoerted to one measure, even if I filter data to represent only one measure at the same time, am I correct?
Sorry for my bad english, and thank you very much.
Anonymous ,
You are correct on your understanding however there can be some workarounds. What is the type of condittional formatting you need?
If the bar is between the warning and the wrong limit, the bar must be yellow. If the bar is higher than the wrong limit it must be red. Otherwise it must be blue.
Anyway, I was searching for a solution and I think that i can't do nothing to make it works, since as you said Power BI don't support right know conditional formatting for more than two measures in the same visual. Maybe if I normalize them I could do some tweaks, but i don't know...
Is it possible to share a mockup of your data?
