Data bar conditional formatting on row total

[RMDNA]

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!

[sailochanar]

can we add data bar to total values ? @AqWP4xjr  @RMDNA  @Icey  @amitchandak  

[AqWP4xjr]

It is frustrating that this still isn't supported in 2023.

[Icey · Accepted 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.

[amitchandak]

@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