Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 there a way to get data bars for APAC's values against the row total of 549?
I know this is easily pivoted to get the data bars to work "as expected," but the client wants it to work the other way.
Thanks!
Solved! Go to Solution.
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.
It is frustrating that this still isn't supported in 2023.
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.
@RMDNA , conditional formatting has been supported in Total recently. Data Bar does not seem to have option for the total.
You can use conditional formatting
User | Count |
---|---|
103 | |
90 | |
78 | |
72 | |
68 |
User | Count |
---|---|
110 | |
96 | |
95 | |
74 | |
71 |