Still after so many years conditional formatting/icon formatting based on text in the current cell is not available. Hope you can add this functionality soon
For example in card visualization. If my status is Red, I would like to change background color to red as well to stand out
For example in a table you can apply conditional formatting based on numbers, percentage or sales, but what about if you want to color formatting based on text taht woukd help a lot for non numeric users!
Thanks in advance!
Actually it is possible to conditional format text in Power BI although it is not so straightforward.
But yes, if there is a direct function would certainly save heaps of time trying to manually write a DAX for it.
Desperately need ability to format cell as well as the entire row in the table visual based on text value. i have a table of features with columns Backlog ID, Title, Status, Size, Assigned to. I want to color the entire row based on status.
If status = "Done" the row background color becomes Green
If status = "In Progress" the row background color becomes Yellow
If status = "Dropped" the row background color becomes Orange
Hi PBI Team,
this feature is very important to be added! It would greatly impove the visualisation of data in a report.
The text based comparisons would be really useful. Hopefully they will be added soon.
I can't believe it isn't still in Power BI.
don't forget columns with boolean data type, while implementing this!
please add this.
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.