Conditional formatting In addition to the visual cues provided by the gauge and KPI visualizations, Power BI also supports visual cues in the form of conditional formatting. Conditional formatting can be used with tables and matrixes to provide background colors, font colors, and data bars for cells within the visualization. To see how this works, […]
Learn Power BI Conditional formatting Read More »
Advanced analysis techniques So far, we have seen how we can segment our data using groups and hierarchies, as well as how to use navigational features such as drill-through, Q&A, and bookmarks to uncover and highlight insights into our data. But Power BI still has more to offer with regard to visual features that also
Learn Power BI Advanced analysis techniques Read More »
Using the COUNTIFS statistical function In our previous edition book, Learn Microsoft Office 2019, we learned all about the COUNTIF function. Let’s look at an example to recap this function, and explore the COUNTIFS function at the same time. Recapping the COUNTIF function In the next topic, we will expand on prior knowledge and discover
Using the COUNTIFS statistical function Read More »
Using the COUNTIFS statistical function In our previous edition book, Learn Microsoft Office 2019, we learned all about the COUNTIF function. Let’s look at an example to recap this function, and explore the COUNTIFS function at the same time. Recapping the COUNTIF function In the next topic, we will expand on prior knowledge and discover
Using the COUNTIFS statistical function Read More »
Removing duplicate data To locate duplicates in a worksheet, follow these steps: To remove duplicates, follow these steps: Figure 9.52 – The Remove Duplicates feature Figure 9.53 – The Remove Duplicates dialog box Figure 9.54 – The results are displayed in the notification popup Another way to remove duplicates will be explained in the next
Removing duplicate data Read More »
Setting up a conditional formatting rule Now that we have the rule in place, we would like to ensure that every time a user selects an item from the drop-down list from a single cell in column L, the color of the row changes accordingly. Remember that you don’t need to set the validation rule
Setting up a conditional formatting rule Read More »
