topic Need condition color formatting for a particular line in Matrix tables in DAX Commands and Tips

Need condition color formatting for a particular line in Matrix tables

Srinivas904 — Tue, 09 Apr 2024 13:23:00 GMT

Hello everyone, I need a urgent help on this I am using 2 measure in a single measure to show with a custom table. I have attched Dax below.

Cumulative Revenue Switch =

SWITCH(

SELECTEDVALUE(Performance[Revenues]), -- Detect the selected row

"FC", [Cumulative FCST],

"Actual Revenue", [Cumulative Revenue],

BLANK() -- Handle other cases (e.g., when nothing is selected)

)

I need a help based on this measure If [Cumulative Revenue] is less than [Cumulative FCST], show red. If it's greater, show green. However, I need this conditional formatting to apply only to the 'Actual Revenue' line. Currently, I'm using one measure for conditional formatting, but it's being applied to both lines, whereas I only want it for the 'Actual Revenue' line.

below is the measure I am using for conditional formatting

Color Measure =

IF(

[Cumulative Revenue] < [Cumulative FCST],

"#EFB5B9", -- Red color code

IF(

[Cumulative Revenue] > [Cumulative FCST],

"#C8F8CD", -- Green color code

BLANK() -- If [Cumulative Revenue] equals [Cumulative FCST], return BLANK

)

Re: Need condition color formatting for a particular line in Matrix tables

Rupak_bi — Tue, 09 Apr 2024 14:19:34 GMT

create flag variable insted of colour and use that for conditional formating

Re: Need condition color formatting for a particular line in Matrix tables

Srinivas904 — Tue, 09 Apr 2024 14:33:27 GMT

Hi Rupak_bi , Thanks for replying any example please ?

Re: Need condition color formatting for a particular line in Matrix tables

Rupak_bi — Wed, 10 Apr 2024 11:26:34 GMT

Hi,

Please share sample data to give you the solution. Mean while try below formula

Color Measure =
IF(

Performance[Revenues]="Actual Revenue",

IF(

[Cumulative Revenue] < [Cumulative FCST],

"#EFB5B9", -- Red color code

IF(

[Cumulative Revenue] > [Cumulative FCST],

"#C8F8CD", -- Green color code

BLANK() -- If [Cumulative Revenue] equals [Cumulative FCST], return BLANK

)

)
,
blank()
)

Re: Need condition color formatting for a particular line in Matrix tables

Anonymous — Tue, 23 Apr 2024 08:31:51 GMT

Hi Srinivas904 ,
Thanks for Rupak_bi reply. According to your description, you are using meaure to populate the value of the matrix. however, meaure needs to rely on the context in order to be computed, so trying to do conditional formatting is not possible. conditional fromatting can only work on the entire value value.
Of course, you can do this by using a table, but you need to create a calculated column.

Best regards,

Albert He

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