Color column conditions

POWER_MI , When they are different measure each having color you can give static color to measure. Conditional formatting is needed when there is something dynamics .

Anyways as measures are returning number, you can not compare with the text

Try like

ColorFormat =
SWITCH (
TRUE (),
not(isblank(MAX ( 'Table'[Mesure_1_NBR_R1] ))), "Red",
not(isblank(MAX ( 'Table'[Mesure_2_NBR_R2] ))), "Green",
not(isblank(MAX ( 'Table'[Mesure_3_NBR_R3] ))), "Pink "
)

Also refer

https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-numbers-in-the-column
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values

Hi POWER_MI ,

I can't understand your issue very well from your description . Based on my understanding, you can use matrix visual instead of table visual. And you can use one measure instead of three measures:

And you can the [color format]:

ColorFormat = 
SWITCH (
TRUE (),
MAX ( 'Table'[Column] ) = "R1", "Red",
MAX ( 'Table'[Column] ) = "R2", "Green",
MAX ( 'Table'[Column] ) = "R3", "Pink "
)

If this post help, please consider accept it as the solution to help other member find it more quickly.

Best Regards,

Dedmon Dai

hello all, 

v-deddai1-msft  thanks for your feed back. 

Here the Values is Number of R1, Number of R2 and Number of R3

We used three mesure to calculte this 

mesure 1=CALCULATE( COUNT('table'[column]), 'table'[column] IN "R1")

mesure 2=CALCULATE( COUNT('table'[column]), 'table'[column] IN "R2")

mesure 3=CALCULATE( COUNT('tablae[column]), 'table'[column] IN "R3")

Is it possible to make one Mesure to calculate number R1 and R2 and R3?

Also the Value on table will be number of R1,R2,R3 depeding on STEP i mean 

if step 1 && 'table'[column]="R1" color Green

if step 2 && 'table'[column]="R1" color Green

if step 3 && 'table'[column]="R1" color Green

if step 4 && 'table'[column]="R1" color ORANGE

if step 5 && 'table'[column]="R1" color ORANGE

if step 6 && 'table'[column]="R1" color RED

Hi POWER_MI ,

Please refer to the pbix file: https://qiuyunus-my.sharepoint.com/:u:/g/personal/pbipro_qiuyunus_onmicrosoft_com/EQToaVM-Vo9Cn58eS90lg9oBdHq_ygXiO8FIhwizkpC6qA?e=6GwsQP

If this post help, please consider accept it as the solution to help other member find it more quickly.

Best Regards,

Dedmon Dai

Hi POWER_MI ,

You can create a slicer table for slicer:

Then you can use the following colorformat:

ColorFormat =
IF (
    SELECTEDVALUE ( Slicer[Value] ) = "A",
    SWITCH (
        TRUE (),
        MAX ( 'COLOR_FIELD_TO_ADD'[Coulumn] ) IN { "R1", "R2", "R31" }, "Red",
        MAX ( 'COLOR_FIELD_TO_ADD'[Coulumn] ) IN { "R2", "R32" }, "Green",
        MAX ( 'COLOR_FIELD_TO_ADD'[Coulumn] ) IN { "R21" }, "Pink "
    ),
    IF (
        SELECTEDVALUE ( Slicer[Value] ) = "B",
        SWITCH (
            TRUE (),
            MAX ( 'COLOR_FIELD_TO_ADD'[Coulumn] ) IN { "R1" }, "Red",
            MAX ( 'COLOR_FIELD_TO_ADD'[Coulumn] ) IN { "R2", "R22", "R31", "R21" }, "Green",
            MAX ( 'COLOR_FIELD_TO_ADD'[Coulumn] ) IN { "R32" }, "Pink "
        ),
        SWITCH (
            TRUE (),
            MAX ( 'COLOR_FIELD_TO_ADD'[Coulumn] ) IN { "R1" }, "Red",
            MAX ( 'COLOR_FIELD_TO_ADD'[Coulumn] ) IN { "R22" }, "Green",
            MAX ( 'COLOR_FIELD_TO_ADD'[Coulumn] ) IN { "R2", "R32", "R31", "R21" }, "Pink"
        )
    )
)

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

Best Regards,

Dedmon Dai

Hi All, 

have you some Updates to have Three rows on Table resultats by grouping choice A( 3 rows), B ( 3 rows) C ( 3 rows) and the differece is on 3 rows Criteria Ri...

thanks

v-deddai1-msft amitchandak