Skip to main content

    Power BI

    New

    conditional formatting intervals

    Vote (97) Share
    's profile image

    on 27 Feb 2017 20:40:46

    It would be very useful to be able to tailor conditional formatting by applying users own definitions for intervals.

    Example being:
    1-3,Red
    4-6,Yellow
    7-9,Green
    or
    1-25%, #5956C3
    26-50%, #C356C1
    51-75%, #5C9B9C
    76-100%, #73C374

    Comments (5)
    's profile image Profile Picture

    8f4d2bd3 3c70-4378-bc16-180502311460 on 16 Aug 2020 04:00:49

    RE: conditional formatting intervals

    Max,

    I have tried conditional formatting on percentages in a column, and this feature is not working. Have you used it successfully on a percentage? And if so, please share how. My values range from .34% to 32.32% and each time I try to add conditional formatting I only get 1 color - no variance.

    's profile image Profile Picture

    5c3ea632 b6ac-4f2e-b1e5-800999e85d9a on 16 Aug 2020 04:00:29

    RE: conditional formatting intervals

    this is now implemented

    's profile image Profile Picture

    75cef349 4a13-4d2b-b953-71ba44e271df on 16 Aug 2020 03:59:06

    RE: conditional formatting intervals

    This is needed

    's profile image Profile Picture

    b215b35b 1ef1-477f-b185-3f38e6f24579 on 16 Aug 2020 03:58:39

    RE: conditional formatting intervals

    I would like to see heat mapping available, highest to lowest, hottest to coldest.

    's profile image Profile Picture

    af0375df 1cc0-46fd-9079-8e87d894fa33 on 16 Aug 2020 03:56:20

    RE: conditional formatting intervals

    This is probably the most important conditional formatting update. Maybe expand to be able to use a formula such as >= 90% green ;. 70 yellow; <=70 red