topic Re: Format background in a matrix table by row by higher than value in DAX Commands and Tips

Format background in a matrix table by row by higher than value

Magnusnilsson — Tue, 09 Apr 2024 13:44:08 GMT

Hi,

I cant find a good solution on this in the forum.

Easy "if" function

IF row A has a value higher than 25000 then RED background

IF row B has a value higher than 40000 then RED background

Else green background

Year	2024
Month	1	2	3
A	5009	26000	20604
B	10438	18800	40507

How do I write this in DAX?

Re: Format background in a matrix table by row by higher than value

Rupak_bi — Tue, 09 Apr 2024 13:06:10 GMT

Hi,

Create a flag variable using the if condition you mentioned then use that flag to do condiotional formatting in matrix visual.

Re: Format background in a matrix table by row by higher than value

johnbasha33 — Wed, 10 Apr 2024 11:05:11 GMT

Magnusnilsson

Select the table or matrix visual that you want to apply conditional formatting to.
Click on the ellipsis (...) in the visual's title bar to open the context menu.
Choose "Conditional formatting" from the menu.
In the conditional formatting pane, select the field (e.g., "A" or "B") for which you want to apply the formatting.
Choose "Background color" from the Format by dropdown menu.
Click on "Advanced controls" to open the advanced formatting options.
Enter the following DAX expression for the background color:
IF (
SELECTEDVALUE ( 'YourTableName'[YourColumnA] ) > 25000 ||
SELECTEDVALUE ( 'YourTableName'[YourColumnB] ) > 40000,
"Red",
"Green"
)

Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!

Re: Format background in a matrix table by row by higher than value

Anonymous — Tue, 30 Apr 2024 09:19:26 GMT

Hi, Magnusnilsson

You can refer to johnbasha33 and Rupak_bi reply, if it does not work, you can try following method.

Measure:

Color = VAR _value = SELECTEDVALUE ( 'Table 3'[Value] ) VAR _category = SELECTEDVALUE ( 'Table 3'[Category] ) VAR _result = IF ( _value > 25000 && _category = "A", "RED", IF ( _value > 40000 && _category = "B", "RED" ) ) RETURN _result

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data in the Power BI Forum