DAX Sales Color (Conditional Formatting) Measure

Notes

Replace [Sales Target] with your own target measure, or a fixed number. Apply this measure under a visual's Conditional formatting > Font color / Background color, set to "Field value".

Requirements

• The Total Sales measure and a Sales Target measure or value.

Builds on these measures

• Total SalesSums a revenue column across whatever filter context is currently applied.

How to use this measure

1. In Power BI Desktop, select the table that should hold the measure and choose New measure on the ribbon.
2. Paste the code, then replace the placeholder table and column names with your own. The My table names fields above do this for you.
3. Run it through the DAX Formatter if you want it laid out in your team's style.

Related DAX measures

• KPI Status IconReturns an up/down/flat arrow based on year-over-year growth, for a compact KPI indicator.
• Total Sales (Hide Zero Rows)Returns BLANK() instead of 0, so visuals can hide rows that have no activity.
• "No Data" MessageReturns a friendly message when a measure would otherwise show blank, for use in a card visual.
• Up / Down Arrow TextReturns an up or down arrow character based on whether a measure increased or decreased versus a comparison period.
• Total SalesSums a revenue column across whatever filter context is currently applied.

More DAX resources

Browse all 175 measures in the Power BI DAX Measures Library, or search the library for something similar to Sales Color (Conditional Formatting).