Skip to main content

    Power BI

    Completed

    Dynamic conditional formatting

    Vote (370) 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.

    Administrator

    This is available already! You can read more about conditional formatting here: Table visualizations in Power BI reports and dashboards - Power BI | Microsoft Docs

    Comments (56)
    's profile image Profile Picture

    Dj 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

    Power BI User 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

    Vishal 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

    David Johnston 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

    Hector Medina 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

    Power BI User 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

    Lazar Jelicic 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

    Chethan K 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

    John Cullom 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

    Antonio Mezzaro 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