Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Missed icons for table conditional formatting

Hi everybody,   I think my issue is quite simple but I'm really unable to find a solution.   I create a simple table with these data and tried conditional formatting with icons.    ...
Need Help
  • v-joesh-msft's avatar
    v-joesh-msft
    6 years ago

    Hi Anonymous ,

    You can use the IF statement to nest, and change the measure: "% CT 2 with area" in the previous demo to the following formulaļ¼š

    % CT 2 with area =
IF (
    ISINSCOPE ( 'Table (2)'[ Area] ),
    DIVIDE (
        SUM ( 'Table (2)'[Qty] ),
        CALCULATE ( SUM ( 'Table (2)'[Qty] ), ALLSELECTED ( 'Table (2)'[ Area] ) )
    ),
    DIVIDE (
        SUM ( 'Table (2)'[Qty] ),
        CALCULATE (
            SUM ( 'Table (2)'[Qty] ),
            ALLSELECTED ( 'Table (2)'[MercatoAgente] )
        )
    )
)

    Best Regards,

    Community Support Team _ Joey
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

PattemManohar's avatar
PattemManohar
Community Champion
6 years ago
Are you sure that you are conditional formatting is on Percent instead of actual values ? If not, then change the "Percent" to "Number" in the drop-down under Rules.