Conditional formatting
In Power BI, you can apply formatting to each visual object, which can be conditioned by a measure, a rule, or a field value that you pass to it. The formatting options will depend on the type of visual object you are using.
For example, consider the table shown in Figure 8.29. It displays a list of average ratings given by users to Airbnb apartments in different neighborhoods of New York City. You can apply conditional formatting to this table to highlight neighborhoods whose rating exceeds 4.6
.
![Figure 8.29: Power BI table with average ratings by neighborhood](https://static.packt-cdn.com/products/9781805120674/graphics/image/B20864_08_29.jpg)
Figure 8.29: Power BI table with average ratings by neighborhood
To apply such formatting, you need to select the visual object and click on the Format visual pane located in the Visualizations section. Then, expand the Cell elements menu. Here, you will find a menu divided into two groups. The first group allows you to choose the indicators added in the columns to which you want to apply the formatting. Then, you have different conditional...