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

in my Power Bi Desktop RS, the CF variable is grayed out, I can't select it :

 

 

  • David23's avatar
    David23
    Frequent Visitor
    3 years ago

    ok. very Big thanks for you 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"
            )
        )
    )