Skip to main content
Microsoft Idea

Power BI

Needs Votes

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

Vote (173) 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

barnaby on 05 Jul 2020 23:52:22

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

I want to show budget spent (as a % bar) on top the budget column.

's profile image Profile Picture

Pilar Sastre on 05 Jul 2020 23:50:57

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

Can't wait to be able to do this. We need the data bar's length to be dependent on the base value, which it already does, but to have the data bar's color (gradient) dependent on a different measure.

's profile image Profile Picture

Samyr Moises on 05 Jul 2020 23:46:39

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

I think that this would be really great if we have it in Matrix and in Table Too!!!!

's profile image Profile Picture

Hauke on 05 Jul 2020 23:43:11

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

Yes, yes, yes!

's profile image Profile Picture

Joshua Harvey on 05 Jul 2020 23:41:59

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

This function is highly needed! Also, if Conditional formatting can me based on a specific cell.

's profile image Profile Picture

Jonas Aust on 05 Jul 2020 23:31:26

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

This would, be a great function.

's profile image Profile Picture

Justin Hylton on 05 Jul 2020 23:31:13

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

Agreed, this is needed. The "Base Value" in the Data bars formatting menu is currently unchangeable.