Power BI Custom Visuals Mastery

Name: Power BI Custom Visuals Mastery
Rating: 4.4 (213 reviews)

Enhance Your Data Storytelling with Advanced Visualizations

Created byMarek Pilczuk

Last updated 4/2023

English

English [Auto],

What you'll learn

Building custom visuals for Power BI.
An alternative approach to the Data Visualization.

Course content

4 sections • 35 lectures • 5h 12m total length

Prerequisites2:23
Identify and meet prerequisites for Power BI custom visuals by confirming coding experience, selecting an editor such as Visual Studio Code, installing Node.js and powerbi-visuals-tools, and enabling developer mode.
powerbi-visuals-tools (Course version)0:08
powerbi-visuals-tools2:05
Certificate Installation2:19
Install the development certificate to prevent browser blocks when using the Power BI service, following Windows PowerShell import steps and placing the certificate in the trusted root authorities.

Project Structure4:47
Initialize a new Power BI custom visual project with pbiviz, explore the default structure: assets, source files (visual.ts, settings.ts), style/visual.less, and config files (capabilities.json, pbiviz.json), and prepare the icon.
Custom Visual Boilerplate6:10
Update of dependencies4:09
The latest version of the powerbi-visuals-tools does not necessarily use the latest version of the dependencies - including powerbi-visuals-api.
For example latest version of the powerbi-visuals-tools (at the time of recording) uses API 3.8.0 when the latest API version is 4.7.0
Starting from version 4.6.0 you must add the "privileges" to your capability.json file.
"privileges": [
{
"name": "WebAccess"
},
{
"name": "LocalStorage"
}
]
Data View Mapping5:48
Define how data maps to your custom visual using data view mappings, focusing on categorical mapping with a maximum of one category, and update capabilities with data roles and conditions.
Data Transformation11:31
Extract data from visual update options in Power BI custom visuals and transform it into a data object with values, table name, and column name, using try-catch to handle data.
Structure of the Visual7:30
Style10:25
Formatting Panel10:13
Learn to configure the Power BI custom visuals formatting panel by defining slicer settings and adding font, padding, margins, and alignment options in capabilities and settings.
Style Settings12:24
Learn to style a Power BI custom visual by wiring formatting panel properties to variables, creating a set style function, and updating visuals in response to slicer settings.
Filtering14:29
Final Touch12:24
Power BI custom visuals mastery guides you through making a slicer interact with the report, enabling filter state synchronization, styling selected items, and preparing the packaging for distribution.
Package6:33
Package your custom slicer visual by updating pbiviz.json metadata with description, support URL, github URL, and email, replace the assets icon with a custom design, and adjust Power BI formatting.

Initial Setup7:23
Data Transformation15:56
Prepare and transform data for Power BI visuals by extracting from update options. Define data interfaces, compute min and max, and format target values for consistent charts.
D3.js7:58
Add an SVG element to a Power BI custom visual with D3, update dependencies, and resize to the visual viewport, preparing for scales in the next lecture.
Scales17:07
Define x and y scales with d3, map categories to the x domain and values to the y domain, and draw a target line using d3 enter update exit.
Space For Target Label9:53
Measure target label width with Power BI visuals utilities and text measurement service; use value formatter to format the measure and measure SVG text to ensure gap matches label width.
Visual Properties8:02
Target Label9:52
Add a target label to the visual by implementing a draw target label function, align its baseline to the middle of the target line, and update text and font attributes.
Data Points10:05
Conditional Formatting15:57
Connectors14:38
Add connectors to a Power BI visual by implementing a set style function, applying default color, line width, font family and size, and drawing connectors through update.
Category Labels8:55
Learn to add and position category labels in Power BI custom visuals, placing labels above or below the target based on data, and refine alignment with styling.
Tooltip10:59
Implement tooltips for a Power BI custom visual by configuring capabilities and using the host tooltip service to show and hide tooltips on mouse over data points.
Cross-Filtering16:12
Highlighting14:14
Master cross filtering and highlighting in Power BI custom visuals by enabling highlight support and marking data points with a boolean highlighted flag.
Package5:10

Initial Setup6:15
Create a new Power BI custom visual, integrate external SVG KPI marks, and configure data roles for value (average sales) and target with data view mappings.
Data Transformation6:04
Extract the value (the average sales) and target from the data view and implement a transform data function to produce a data object for a Power BI custom visual.
Layout5:15
Prepare the KPI label layout for a Power BI custom visual by creating an icon container and enforcing a square SVG area from the viewport height.
External SVG9:45
Add an external svg icon to a Power BI custom visual and update its path based on whether the current value is above or below the target.

Requirements

HTML and CSS knowledge is needed
TypeScript knowledge is required.
Some experience with d3js is required. If you never used D3 I recommend first enrolling in my course "D3 .js - the art of data visualization"
Code editor (Visual Studio Code recommended)
Internet Browser (Google Chrome recommended)
Account in Power BI.

Description

Unlock the full potential of Power BI by learning to create custom visuals that transform your data into compelling stories. This course will guide you through the process of developing three unique custom visuals that enhance the standard visuals available in Power BI.

Throughout the course, you will gain hands-on experience in building:

Custom Slicer: Create an intuitive single-choice menu with a separate filter reset option to simplify data navigation.
Lollipop Chart: Visualize performance against targets, complete with tooltips, cross-filtering, cross-highlighting, and conditional formatting for a truly interactive experience.
KPI Label: Design dynamic labels that display different icons based on whether the average value is above, on, or below the target. Learn to incorporate external SVG designs to enrich your custom visuals.

Key takeaways from this course include:

Understanding the structure of a custom visual project
Implementing tooltips, cross-filtering, and cross-highlighting
Applying conditional formatting to your visuals
Utilizing Microsoft Power BI Visuals Formatting Utils
Creating slicers with powerbi-models
Embedding externally-created SVG graphics into your custom visuals

Please note: This course assumes prior knowledge of D3.js. If you're new to D3, I recommend enrolling in our "D3.js - The Art of Data Visualization" course first.

Enroll now to unlock the power of custom visuals in Power BI and elevate your data storytelling skills to new heights.

Who this course is for:

Developers eager to learn how to create custom visuals for Power BI.
Data Architects who wants to presents information in the more appealing way.
Everyone who has fun programming cool things.

Power BI Custom Visuals Mastery

What you'll learn

Explore related topics

Course content

Introduction4 lectures • 7min

Custom Slicer12 lectures • 1hr 46min

Lollipop Chart15 lectures • 2hr 52min

KPI Label4 lectures • 27min

Requirements

Description

Who this course is for: