DAX and Conditional Formatting Better Together: Find The Biggest and Smallest Numbers in the Column

In the previous article, I explained the importance of Conditional formatting and mentioned that having a table with no color coding is not a proper way of giving information to your users. In this article, as the second step; I’m going to show you how to use DAX combined with conditional formatting to only highlight the biggest and the smallest number in a column in a table. If you have used the conditional formatting, you are aware that you cannot do the formatting just by saying give me the highest number, or the two top highest numbers. In the Power BI world, DAX is your friend, so let’s see how DAX in combination with conditional formatting can do that for you. If you like to learn more about Power BI, read Power BI from Rookie to Rock Star book.

Read the rest of the article from here: https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-numbers-in-the-column