Conditional formating using DAX

Hi c_banerjee

Follow below steps to add conditional formatting -

1. Select the visual and go to Visual formatting Pane > Cell Elements

2. Select the column/field you want to apply conditional formatting

3. Toggle "On" Background color or font color based on your requirement.

4. A window opens to select the colour options, Select "Field Value" under Format style and select measure created under "What field should we base this on?" (in your case - Margin Color). Click Ok and conditional formatting is applied to the filed choosen.

Sample Example Result - I have applied background color for State column based on Measure.

💡 Helpful? Give a Kudos 👍 — keep the community growing
✅ Solved your issue? Mark as Solution ✔️ — help others find it faster

Best regards,
Rupasree Achari | BI & Fabric Analytics Engineer 

For a table or matrix visual:

Select your table or matrix visual.
In the Visualizations pane, go to the Values section.
Find the Margin field.
Click the dropdown arrow next to the Margin field.
Select Conditional formatting.
Choose Background color or Font color.
In the dialog box, set Format by to Field value.
In Based on field, select your measure Margin Color.
Click OK.

For a chart (bar, column, etc.):

Select the chart visual.
Open the Format pane.
Expand the Data colors section.
Click the Advanced controls or fx option.
Set Format by to Field value.
Select your measure Margin Color.
Apply the changes.

Important note:
Make sure your measure returns valid color values such as Red, Green, or hex codes like #FF0000.

Hi,

Your DAX measure looks fine, but whether you can use it for conditional formatting depends on the visual you're using.

A few things to check:

• Make sure you're using a visual that supports conditional formatting (such as a Table or Matrix).

• Select the visual, then in the Values well, click the drop-down arrow next to the Margin field and look for Conditional formatting (or Cell elements in newer versions of Power BI).

• Choose Background color or Font color, then select Format by → Field value and choose your Margin Color measure.

If you don't see the Conditional formatting option:

• Verify that you're using a Table or Matrix visual, as not all visuals support field-value formatting.

• Ensure the measure returns valid color names (e.g., "Red", "Orange") or hexadecimal color codes (e.g., #FF0000), which are generally more reliable.

• Confirm that the field you're formatting is in the Values section of the visual.

Could you let us know:

• Which visual are you using (Table, Matrix, Card, etc.)?

• Which version of Power BI Desktop are you using?

• Are you trying to color the text, the background, or something else?

The Microsoft documentation on conditional formatting may also help:
https://learn.microsoft.com/power-bi/create-reports/desktop-conditional-table-formatting

If you found this reply helpful, please consider giving it a Kudos. If it helps resolve your issue, marking it as the Accepted Solution will help others facing the same problem.

Hi c_banerjee,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. 

Thank you.