Skip to main content
Microsoft Idea

    Power BI

    Needs Votes

    Conditional formatting in matrix by field doesn't work with data bars

    Vote (172) Share
    's profile image

    on 30 Aug 2018 16:25:24

    Please add the ability in conditional formatting to show "Data bars" based on a different field. Just like you can show "Background color" or "Font color" based on a field you can choose. At this moment it is not consistent behaviour and I really need this for managementreporting as I want to show the numbers in the columns but show the bars based on a percentage that is spend.

    Lots of love!

    Comments (17)
    's profile image Profile Picture

    Phil Trick on 21 Sep 2023 20:47:57

    RE: Conditional formatting in matrix by field doesn't work with data bars

    This would be an incredible feature to have.

    's profile image Profile Picture

    James Beuzeval on 13 Sep 2023 09:23:49

    RE: Conditional formatting in matrix by field doesn't work with data bars

    I'm trying to display an absolute value in a column but with a data bar behind it displaying what percentage that value is relative to another value. Essentially just a case of allowing a data bar to display another another field or measure.

    's profile image Profile Picture

    Konstantin Volke on 25 Feb 2022 09:55:49

    RE: Conditional formatting in matrix by field doesn't work with data bars

    I also want to show a percentage as a bar and the absolute value in the matrix. Would be a hot feature.

    's profile image Profile Picture

    Jens Eggerath on 09 Nov 2021 12:10:40

    RE: Conditional formatting in matrix by field doesn't work with data bars

    Please consider implementing this!

    This would allow us to "synchronize" scales between multiple columns by putting a normalized [1,0] measure onto the bar length. --> Same as the visual benefit of small multiples: same visual scale.

    's profile image Profile Picture

    Marshall Benson on 17 Sep 2021 20:19:39

    RE: Conditional formatting in matrix by field doesn't work with data bars

    Hello, 
    We could really use this feature! Please, update us soon :)

    's profile image Profile Picture

    - Power BI User on 21 Aug 2020 00:03:30

    RE: Conditional formatting in matrix by field doesn't work with data bars

    Definitely need to be able to display the value, but format databars as a % of the whole

    's profile image Profile Picture

    Power BI User on 10 Jul 2020 17:21:12

    RE: Conditional formatting in matrix by field doesn't work with data bars

    after so long, no status yet from the developers?

    's profile image Profile Picture

    Tim on 06 Jul 2020 00:08:39

    RE: Conditional formatting in matrix by field doesn't work with data bars

    I want to show the same value, but I have one metric as a number and the other as a formatted number (Text)

    's profile image Profile Picture

    Aly on 06 Jul 2020 00:05:45

    RE: Conditional formatting in matrix by field doesn't work with data bars

    This would be a wildly useful feature and I hope that it's in the works.

    's profile image Profile Picture

    Michael Shparber on 05 Jul 2020 23:56:13

    RE: Conditional formatting in matrix by field doesn't work with data bars

    Very needed - please help.
    I also need the length to be based on another measure (maximum number)
    Thanks