Power BI

New

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

Vote (87)

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 (12)

Comments (12)

6f219e4c cc3b-4dc6-84c8-88c004684a06 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

15bda12a ceba-468e-be59-4d743b434d00 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?

103b6df0 640e-4487-8b9d-bc8c3c5d16a6 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)

ac979fb1 e70e-4518-8407-b84cb1386d62 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.

f93db4e6 f311-45fb-8754-72b611fa2a9b 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

c741c2af 06ef-4e79-93f5-6cfe791d6501 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.

2bd4fe65 c085-4ce6-921a-23605dce2105 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.

9d8b170b 371e-4ae2-8f14-9c1a622f2e16 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!!!!

a3898d52 095f-4635-a24d-40bdbcec0d83 on 05 Jul 2020 23:43:11

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

Yes, yes, yes!

18f5c203 117c-4234-acb4-be2db72810bf 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.