Spetter
Advocate IV
Advocate IVStatus:
Needs Votes
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!
19 Comments
- This would, be a great function.
- Agreed, this is needed. The "Base Value" in the Data bars formatting menu is currently unchangeable.
- This function is highly needed! Also, if Conditional formatting can me based on a specific cell.
- Yes, yes, yes!
- I think that this would be really great if we have it in Matrix and in Table Too!!!!
- 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.
- I want to show budget spent (as a % bar) on top the budget column.
- Very needed - please help. I also need the length to be based on another measure (maximum number) Thanks
- This would be a wildly useful feature and I hope that it's in the works.
- I want to show the same value, but I have one metric as a number and the other as a formatted number (Text)
