Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Dynamic conditional formatting

Instead of hardcoding a number to use on formatting a table, allow users to use a measure/calculation (DAX) to format dynamically a table.
Status: Completed
Comments
sankalp_jain
New Member
This is one of the places where powerbi is lacking. People want to see formatting on dynamic values and rarely on static values. Please implement
fbcideas_migusr
New Member
Please add a feature such that we can apply a range of conditions to a column. (i.e.) Status= "Fail" font color is Red Status= "On Time" font color is Green Status = "On Risk" font color is Yellow
david_johnston2
New Member
I'd also really like to see this added. If you have different goals or targets for different categories (dimensions) within a visualization, it's impossible to correctly use conditional formatting until Power BI (or at least the relevant visualizations) allow for conditional formatting based on a measure.
VISHAL_NARKAR
New Member
It would be great to be able to apply a range of conditions to a column based on date field e.g. DateField1 > CurrentDate AND Status= Incomplete, row/font color is Red DateField1 < CurrentDate AND Status= Incomplete, row/font color is Yellow etc..... Other values font color is black
danielj_brady
New Member
Really need to highlight the entries for ease of viewing.
Deborah_Walker
New Member
I have many uses for functionality which will allow conditional formatting by a text value in a column or by a field header. I agree with others that it is basic, but must-have.
alena_azbel1
New Member
Being able to apply conditional formatting based on different measure/dimension than displayed in the values is crucial to provide concise and clear information with little visible elements on the screen. It's really useful and requested in vast majority of cases
satin_malik
New Member
I really need this feature since the many customers asked to incorporate conditional formatting based on parameter selection. For e.g. Condition based on the what if Parameter slicer. This would increase the flexibility of defining conditions in Matrix visual or Table Visual. Even this should be applicable in column and Bar charts.
mvheur
New Member
Pity that it PBI is not able to use the output of other colums to add conditional formating colours. Example= if i have a column ACTUAL and a column BUDGET, then i want to have my Actual in red in case the amount is bigger than Budger. This is not possible unless i create a new calculated column but this is not the proper solution. So, please make it work.
FredTheFrog
Advocate I
My business users are seriously requesting the ability to alter the color of a TEXT value as opposed to NUMBER values in a table. If I can format Column X using a value from Column Y or Column Z, that would satisfy them.