Forum Discussion

RMDNA's avatar
RMDNA
Icon for Solution Sage rankSolution Sage
6 years ago
Solved

Data 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 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!

Need Help
  • Icey's avatar
    Icey
    6 years ago

    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.

5 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    6 years ago

    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

    • JustSayJoe's avatar
      JustSayJoe
      Icon for Advocate IV rankAdvocate IV
      2 years ago

      Conditional formatting data bars only work on the column total. It would be really nice if we could have the data bar display based upon a measure that is formatted as a percentage.

  • Icey's avatar
    Icey
    Icon for Community Support rankCommunity Support
    6 years ago

    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.

  • AqWP4xjr's avatar
    AqWP4xjr
    Icon for Advocate II rankAdvocate II
    3 years ago

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