Power BI Journey: Blog #6

In this lesson, the focus is on "Conditional Formatting" which is very much similar to the conditional formatting in MS Excel which I could relate to following the making of the joint reporting system for personnel during my second job.

Basically, we click the data columns that we want to be displayed in a tabular visualization. 

Next, we select the columns that we will be applying conditional formatting to > Right-click on that column > Select Conditional Formatting > Select from among the options which is more appropriate for your application

In this particular exercise, we utilized Background conditional formatting using gradient (applied on the first column of the first table) and rules (IF ELSE which was applied on the second column of the first table), Icons conditional formatting (applied on the second column of the first table), Data bars conditional formatting (applied on the second column of the first table and the fourth column of the second table).

In the first table, it shows that too much conditional formatting is not ideal. The conditional formatting used must be appropriate for the application. Notice also that most of the conditional formatting can ONLY be done when the visualization is in tabular form, same as with MS Excel.