Forum Discussion
RMDNA
Solution Sage
Solution SageData bar conditional formatting on row total
Hi all, Just a quick question - can you get the conditional formatting data bars against a row total rather than a column total? I can get data bars for the TU column against a total of 27, but is t...
Hi RMDNA ,
How about this?
Simple example:
AreaCategoryValue
APAC TU 1 APAC TC 10 APAC C 20 APAC NT 30 Australia TU 5 Australia TC 15 Australia C 25 Australia NT 35 Canada TU 1 Canada TC 10 Canada C 20 Canada NT 30 CEEA TU 1 CEEA TC 10 CEEA C 20 CEEA NT 30 1. Create a measure like so:
Row total % = IF ( ISFILTERED ( 'Table'[Area] ) && ISFILTERED ( 'Table'[Category] ), -----display total value as blank SUM ( 'Table'[Value] ) / CALCULATE ( SUM ( 'Table'[Value] ), ALLEXCEPT ( 'Table', 'Table'[Area] ) ) )2. Create a Matrix visual like so:
BTW, .pbix file attached.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Icey
Community Support
Community SupportHi RMDNA ,
How about this?
Simple example:
AreaCategoryValue
| APAC | TU | 1 |
| APAC | TC | 10 |
| APAC | C | 20 |
| APAC | NT | 30 |
| Australia | TU | 5 |
| Australia | TC | 15 |
| Australia | C | 25 |
| Australia | NT | 35 |
| Canada | TU | 1 |
| Canada | TC | 10 |
| Canada | C | 20 |
| Canada | NT | 30 |
| CEEA | TU | 1 |
| CEEA | TC | 10 |
| CEEA | C | 20 |
| CEEA | NT | 30 |
1. Create a measure like so:
Row total % =
IF (
ISFILTERED ( 'Table'[Area] ) && ISFILTERED ( 'Table'[Category] ), -----display total value as blank
SUM ( 'Table'[Value] )
/ CALCULATE ( SUM ( 'Table'[Value] ), ALLEXCEPT ( 'Table', 'Table'[Area] ) )
)
2. Create a Matrix visual like so:
BTW, .pbix file attached.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.