Forum Discussion

David23's avatar
David23
Frequent Visitor
3 years ago
Solved

Alternate matrix row colors

Hello I work with Power Bi Desktop RS. I want a dynamic background color. I explain myself with the image below: I want the lines of area 1, 3 and 5 to be with a red background color. and the li...
Need Help
David23's avatar
David23
Frequent Visitor
3 years ago

I increased the measure in the conditional formatting. but the display is not at the top :

 

 

 

here is the script used :

 

Me_CF2 = 
VAR _Rnk =
    IF (
        ISBLANK ( [S-Revenue_actual] ),
        BLANK (),
        CALCULATE (
            RANKX ( ALLSELECTED ( DIM_PRODUCT ), [S-Revenue_actual],, DESC ),
            ALLEXCEPT ( DIM_PRODUCT, DIM_PRODUCT[pr_offer] )
        )
    )
RETURN
    IF (
        NOT ISINSCOPE ( DIM_PRODUCT[pr_offer] ),
        "White",
        IF (
            NOT ISINSCOPE ( Dim_Time[Period] ),
            "White",
            IF (
                AND ( ISINSCOPE ( DIM_PRODUCT[pr_offer] ), ISEVEN ( _Rnk ) ), 
                "#EFB5B9",
                "#A0D1FF"
            )
        )
    )