Controlling Conditional Formatting Using DAX
Written by Nathaniel Scharer on . Posted in Tabular DAX
Power BI has long had the ability to apply conditional formatting to values in table columns. However, many felt that the functionality for managing the colors and parameters used in Power BI Desktop was too limited and didn’t provide the level of granular control desired by many users. In a recent update to Power BI Desktop, Microsoft has addressed this limitation and introduced the ability to use DAX measures to control the conditional formatting of table columns. As we’ll see in this blog post, by creating a simple measure using the SWITCH function, users can take granular control of conditional formatting and apply it to values in columns.