Conditional formatting is an option that has been gradually added to Table and Matrix visual. Now we can safely say that Power BI Desktop has almost everything we used in Excel to build the reports where we applied this option. As of July 2019, conditional formatting also supports icon sets, and in the text below you will be able to learn how to use all of these options.
Conditional formatting is not new feature, but so far Power BI users have been able to use it exclusively in visuals that contain some sort of table. The novelty brought by the improved version of the november 2018 is that the Saturation field has been abolished, and the option for conditional formatting has been added instead. Let’s see what it brings!
I often get upset when I go to the supermarket and see the workers closing the passages by racking up the shelves. How to help them? If a company has implemented an ERP, it is possible to extract a stock report, critical inventory, and a place where the items are located (warehouse, location, position). With a little imagination and knowledge of conditional formatting techniques, there is an easy way to mark those shelves and positions where urgent refill is required.
In several previous posts I wrote about the formatting of the contents of the cell. In addition to the standard ways of displaying its content, users can also define custom views. User-defined formats can be greatly used to enrich the appearance of the report. Using them, we achieve effects similar to the conditional formatting technique, and we can easily copy them or use them to create formatting styles.
Conditional formatting allows us to customize the way that cell or group of cells is displayed in order to highlight their values. When using conditional formatting options, we can use some of the predefined rules discussed earlier. However, we often want to set the rules for formatting independently, to determine the order of their operation, or to disable some of them …