Course: Microsoft Power BI: Advanced Data Analysis and Visualisation

Configure Conditional Formatting Conditional formatting in Power BI Desktop allows you to specify customized cell colors, including color gradients, that is based on field values. Additionally, you can use conditional …

Use Advanced Interactions And Drill Through To ensure that you have full control over the behavior of your report and can determine the expected user experience, you can edit the …

Introduction Organisations use reports to monitor and record performance and identify trends and variances. When an organisation is making decisions, it relies on the information that is provided by reports. …

Work With Key Performance Indicators Key performance indicators (KPIs) are excellent in helping you track progress toward a specific goal over time. To use a KPI, you need three pieces …

Importing A Custom Visual In addition to the out-of-the-box visualizations in Power BI Desktop, hundreds of other developers have created a multitude of visuals for you to choose from. If …

Format and Configure Visualizations Power BI Desktop gives you a variety of options for customizing how your selected visualizations look, such as the colors and format of the text that …

Data Visualisation Power BI Desktop offers a range of out-of-the-box visualization options that are available directly from the Visualizations pane. When you select the fields that you want to display …

Work With Time Intelligence All data analysts will have to deal with time. Dates are important, so we highly recommend that you create or import a dates table. This approach …

Create Semi-Additive Measures In situations where you don’t want the standard evaluation behaviour in Power BI, you can use the CALCULATE and/or USERELATIONSHIP functions. However, more circumstances exist where you …

Use the Calculate Function The CALCULATE function in DAX is one of the most important functions that a data analyst can learn. The function name does not adequately describe what …

Introduction To DAX Data Analysis Expressions (DAX) is a programming language that is used throughout Microsoft Power BI for creating calculated columns, measures, and custom tables. It is a collection …

Work With Relationship And Cardinality Unlike other database management systems, Power BI has the concept ofdirectionality  to a relationship. This directionality, or cardinality, plays an important role in filtering data between …

Define Data Granularity Data granularity is the detail that is represented within your data, meaning that the more granularity your data has, the greater the level of detail within your …