Advanced Visuals and Custom Visuals
Advanced visuals help users analyze business performance beyond basic charts and tables. They can explain relationships, compare actual performance with targets, analyze distributions, and communicate complex information. Custom visuals can extend Power BI with additional visualization options when standard visuals do not meet a specific reporting requirement.
Learning Objectives
- Understand common advanced Power BI visuals.
- Identify when to use scatter charts, waterfall charts, and funnels.
- Understand gauge and KPI visuals.
- Explore the purpose of custom visuals.
- Evaluate visual suitability, usability, and security considerations.
- Build a report page that communicates advanced business insights.
1. What Are Advanced Visuals?
Advanced visuals are useful when a business question requires more than a simple comparison or trend. Different visuals reveal different types of information, so the correct choice depends on the purpose of the analysis.
Advanced Visual Selection
2. Scatter Charts
A scatter chart displays the relationship between two numeric variables. Each point represents an observation, such as a product, customer, or store. It can help identify clusters, unusual values, and possible relationships between measures.
Example: Advertising Spend and Sales
In this illustration, higher advertising spend tends to be associated with higher sales. This pattern alone does not prove that advertising caused the increase.
How to Create a Scatter Chart
- Select the Scatter Chart visual.
- Add a numeric measure to the X-axis.
- Add another numeric measure to the Y-axis.
- Use a category or identifier to distinguish individual observations when appropriate.
- Optionally add a size measure or legend category if supported by the visual.
- Inspect clusters and outliers before drawing conclusions.
3. Waterfall Charts
A waterfall chart shows how a starting value changes through a sequence of positive and negative contributions until it reaches an ending value. It is useful for explaining changes in profit, revenue, expenses, and budget variance.
Example: Profit Movement
When to Use a Waterfall Chart
- Explaining changes from budget to actual results.
- Showing how revenue and costs affect profit.
- Investigating month-to-month financial movement.
- Explaining the contributions that produce a final total.
4. Funnel Charts
A funnel chart shows values across sequential stages of a process. It is often used for sales pipelines, recruitment processes, customer journeys, and lead conversion analysis.
Example: Sales Pipeline
How to Create a Funnel Chart
- Select the Funnel visual.
- Add a stage field, such as Lead Stage, to the category or group field well.
- Add a measure, such as Lead Count, to Values.
- Ensure the stages follow the correct business sequence.
- Format data labels and titles to make stage values easy to read.
5. Gauge and KPI Visuals
Gauge and KPI visuals communicate progress toward a goal. A gauge typically compares a current value with a target or defined range. A KPI visual can communicate performance and, when configured, a trend against a goal.
Gauge Concept
Example DAX Measures
Total Sales
Total Sales = SUM(Sales[SalesAmount])
Sales Target
Sales Target = 100000
Target Achievement Percentage
Target Achievement % =
DIVIDE([Total Sales], [Sales Target], 0)
Format Target Achievement % as a percentage. Add the appropriate measures to a gauge or KPI visual and configure the target and trend fields according to the visual's available field wells.
6. Custom Visuals
Custom visuals extend the standard visualization options available in Power BI. They can provide specialized chart types, layouts, or interactions for reporting needs that standard visuals do not fully address.
| Visual Category | Potential Use | Evaluation Question |
|---|---|---|
| Advanced Charts | Specialized comparisons or distributions | Is the visual easier to understand than a standard chart? |
| Process Visuals | Stages, dependencies, or workflows | Does it accurately represent the process? |
| Specialized Tables | Additional layouts or conditional displays | Does it improve readability? |
| Industry-Specific Visuals | Specialized operational or analytical reporting | Does it meet the reporting requirement? |
7. How to Add a Custom Visual
- Open the report in Power BI Desktop.
- Locate the option for obtaining or importing additional visuals.
- Review the available visuals and their documentation.
- Check the publisher, permissions, support information, and organizational policies.
- Add the approved visual to the report.
- Assign the required fields and configure the formatting options.
- Test the visual in Desktop and in the intended sharing environment.
8. Standard vs. Custom Visuals
| Consideration | Standard Visual | Custom Visual |
|---|---|---|
| Availability | Built into Power BI | May need to be obtained or imported |
| Setup | Usually straightforward | Depends on the visual |
| Specialized features | Depends on built-in capabilities | May provide additional capabilities |
| Governance | Follow organizational Power BI policies | May require additional review and approval |
| Maintenance | Managed as part of Power BI | Can depend on the publisher and version |
9. Choosing the Right Advanced Visual
Visual Selection Guide
10. Practice Activity
Scenario: Business Performance Dashboard
A company wants to analyze its sales pipeline, advertising performance, and progress toward its monthly sales target.
Tasks
- Create a scatter chart to compare advertising spend with sales.
- Create a funnel chart to show lead counts across sales stages.
- Create a waterfall chart to explain the movement from starting profit to ending profit.
- Create a gauge or KPI visual to compare total sales with the monthly target.
- Investigate one custom visual that could meet an additional reporting requirement.
- Document why each visual was selected and what insight it communicates.
- Validate the calculations and confirm that the labels explain the results.
11. Knowledge Check
Question 1: Which visual is useful for exploring the relationship between two numeric variables?
A. Scatter chart
B. Card
C. Basic text box
Question 2: Which visual commonly represents sequential process stages?
A. Funnel chart
B. Donut chart
C. Card
Question 3: What is an important consideration before adding a custom visual?
A. Review its suitability, publisher, and organizational policies.
B. Use it without checking its behavior.
C. Remove all report labels.
Question 4: What does a waterfall chart help explain?
A. Contributions that move a value from a starting point to an ending point.
B. Geographic coordinates only.
C. The structure of a report page.
Show Answers
- Question 1: A — Scatter chart.
- Question 2: A — Funnel chart.
- Question 3: A — Review its suitability, publisher, and organizational policies.
- Question 4: A — Contributions that move a value from a starting point to an ending point.
Summary
In this lesson, you learned how advanced Power BI visuals support relationship analysis, process tracking, financial movement, and target monitoring. You explored scatter charts, waterfall charts, funnel charts, gauge visuals, and KPI visuals, along with the purpose of custom visuals.
Select visuals according to the business question, validate the underlying data, and use clear formatting to communicate results. Before using custom visuals, review their functionality, publisher, and applicable organizational security requirements.