and not only from cells text, we need the posibility to select a value from query or table
Agreed. This seems well overdue for this product.
Unbelievable this is not yet possible. We try to switch our users to PowerBI from our legacy reporting tool but with lot of functionality we have to tell them... its not (yet) possible. It feels like going backwards.
The ability to conditionally format text in a table is more important than supporting this for numbers. I find it inexplicable that you would release such a half baked feature particularly when this is something so easily achieved in Excel.
Imagine a matrix with rows representing some list of systems, and a column which displays pass/fail or perhaps operational/non-operational. I want to show good rows as green, bad rows as red. One simple way to do this would be to allow conditional formatting for a cell on any value in the row, even values that aren't displayed. I could create a calculated column which is a number like zero or one. Then I could format "pass" as green if the hidden value is 1, or red for 0.
This is essential for me as a data analyst in a school where we use alphanumeric grades. In a matrix I am limited to conditional formatting only if all values in the matrix are numbers - seems crazy. I\d like to be able to conditionally format values in one field based on the value in another
PLEASE DO THIS!!!!
Really wish you geniuses could get on this one. It can't be that hard. Both for regular tables as well as a Matrix.
Is there a way to conditional format a card?
I need to display a value, if the number is less than 50%, I need to set the background to red, otherwise green.
Conditional formatting is always helpful when grouping table type data and the values are not numbers but text.
Administrator on 8/3/2022 5:06:29 AM
This month we added the ability to format text fields based off a numeric field: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-may-2018-feature-summary/#conditionalFormatting We also are planning on adding a feature that will let you format your text based on comparisons. I'll update this idea based on our progress on that feature.