Forum Discussion
Conditional formating using DAX
c_banerjee Same measure mentioned I have used for checking Sales in below table and added conditional formatting to Region as below -
💡 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.
there is format ,build and data pane, format pane has visual and properties, i didnot find anything called data colors, however there is a cell element which has background color selected fx, selected field value what field should we base this on selected margin color.. what why everything is orange!