Skip to main content

Power BI

Needs Votes

Dynamic conditional formatting

Vote (357) Share
's profile image

on 01 Nov 2016 02:45:10

Instead of hardcoding a number to use on formatting a table, allow users to use a measure/calculation (DAX) to format dynamically a table.

Comments (56)
's profile image Profile Picture

3de63169 b432-46fd-b62a-52e8c836ba0b on 05 Jul 2020 23:04:49

RE: Dynamic conditional formatting

Really need to highlight the entries for ease of viewing.

's profile image Profile Picture

e1f05308 9334-49f7-b8bd-dbbc620dea1a on 05 Jul 2020 23:04:28

RE: Dynamic conditional formatting

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.

's profile image Profile Picture

47f04c85 e444-4c73-9921-23f411565b1e on 05 Jul 2020 23:03:43

RE: Dynamic conditional formatting

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

's profile image Profile Picture

e6ea363e 8d8f-4900-8e8e-1dc4b2e5d29b on 05 Jul 2020 23:01:39

RE: Dynamic conditional formatting

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.

's profile image Profile Picture

f8012ae3 f8dd-46e8-b7a5-5bb570beb0b8 on 05 Jul 2020 22:59:06

RE: Dynamic conditional formatting

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

's profile image Profile Picture

7fc686d5 722d-4162-806a-14efffa5186d on 05 Jul 2020 22:58:49

RE: Dynamic conditional formatting

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

's profile image Profile Picture

f244ef1d 3ca1-4c21-9ffc-880b822fe9ec on 05 Jul 2020 22:58:39

RE: Dynamic conditional formatting

it would be very useful, they would get an additional dimension

's profile image Profile Picture

aac4ac02 57c3-40cb-8589-4e3c044e13e2 on 05 Jul 2020 22:57:22

RE: Dynamic conditional formatting

Dependency condition format is require because its very Important for present

's profile image Profile Picture

9249900a cda0-421d-a970-ca2699141040 on 05 Jul 2020 22:56:51

RE: Dynamic conditional formatting

I could use this. Currently exists in SSRS and want to move tons of reports.

's profile image Profile Picture

a03aba49 627f-409b-9c27-b43cee43435a on 05 Jul 2020 22:55:45

RE: Dynamic conditional formatting

Every format attribute should be either a constant either the result of a calculation