Conditional formatting in matrix by field doesn't work with data bars
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!
I want to show the same value, but I have one metric as a number and the other as a formatted number (Text)
This would be a wildly useful feature and I hope that it's in the works.
Michael Shparber commented
Very needed - please help.
I also need the length to be based on another measure (maximum number)
I want to show budget spent (as a % bar) on top the budget column.
Pilar Sastre commented
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.
Samyr Moises commented
I think that this would be really great if we have it in Matrix and in Table Too!!!!
Yes, yes, yes!
Joshua Harvey commented
This function is highly needed! Also, if Conditional formatting can me based on a specific cell.
Jonas Aust commented
This would, be a great function.
Justin Hylton commented
Agreed, this is needed. The "Base Value" in the Data bars formatting menu is currently unchangeable.