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
Solution SageHi 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
Solution Sagec_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
hi Rupa01
But now the issue whole column is orange, what im doing wromg here, is there any problem with measure margin color? or measured column total_sales[margin]- Rupa01
c_banerjee Check the values of the Margin column - if all the values is less than 0.4, < 0.4 condition is satisfying as result orange you are getting.
Please share the sample data or screenshot of the visual or pbix file - if require assistance.
- Ashish_Mathur
Super User
Hi,
Could you kinldy share the download link of the PBI file.
