Рет қаралды 1,713
In this video, you'll learn how to create your own SVG sparkline charts and add them to the new card visual in Power BI.
To shortcut the process we'll start by using one of the SVG sparkline accelerator templates provided by a blogger called Kerry Kolosko.
We'll then take that base template and customise it to meet our specific requirements with the help of ChatGPT.
This is a great approach if you want to start using the flexibility of design that SVG charts offer, without having to spend a load of time understanding exactly how to code up SVG file formats.
Part 1: What are SVGs?
We start with a brief overview of what an SVG file format is and why it's useful to us in Power BI.
Part 2: Importing Accelerator Sparkline Measure Template
We then move on to importing an SVG sparkline accelerator template provided by Kerry Kolosko (kerrykolosko.com/portfolio-ca...) and updating it to match our data model.
Part 3: Customisation Using ChatGPT
Finally, we will walk through the steps of how you can customise the base accelerator template with the help of ChatGPT to update the look and feel to be exactly what you need for your visualisation.
----------------------------------
⏩ Video Navigation
----------------------------------
00:00 - Introduction
00:47 - Learning about SVGs
04:00 - Using SVG Accerlator Templates
06:25 - Dealing with Date Grain Difference
09:03 - Adding the SVG Sparkline to the Card Visual
10:39 - Modifying the SVG - Change Line Details
13:20 - Adding a debug border around the SVG Using ChatGPT
15:58 - Adding difference of the period number Using ChatGPT
17:55 - Add Up / Down arrow indicator Using ChatGPT
19:31 - Adding up / down conditional formatting using ChatGPT
23:23 - Fine turning the position of the difference text
24:20 - Removing the debug border and adding the background image
25:45 - Adding an SVG measure to a table visual
26:40 - Final thoughts
-----------------------------------------------------
🎥 Related Videos & Pages
-----------------------------------------------------
My Other New Card Visual Videos:
New Card Visual Video 1 - Power BI's Stunning New Card Visual Explained
• Power BI's Stunning Ne...
New Card Visual Video 2 - Enhance the Amazing New Power BI Card Visual with Conditional Formatting of ICONs and Accent Bars
• Enhance the Amazing Ne...
SVGs In Power BI Useful Resources:
SVG Accerlator Templates
kerrykolosko.com/portfolio-ca...
Matrix Revolutions: Putting the "Whoa" into PBI Matrix with dynamic SVG - Daniel Marsh-Patrick
• Matrix Revolutions: Pu...
IBCS Styled Bullet Chart for Native Tables in Power BI!
• IBCS Styled Bullet Cha...
SVG File Formats Explained
www.youtube.com/@KevinPowell/...
Simple SVG Editor
editor.method.ac/
SVG Reference Guide
www.w3schools.com/graphics/sv...
-----------------------------------------------------
🎓 Power BI Dashboard Training
-----------------------------------------------------
👉FREE Power BI Quick Start Course - Learn how to create your first dashboard in around 90 minutes!
effectivedashboards.com/power...
👉 Power BI Quick Start PLUS - Learn how to craft KPI management dashboards that help you, your boss, and your peers make better decisions!
effectivedashboards.com/power...
-------------------------
📁 Resources
-------------------------
👉Access to the source PBIX files for this KZbin video:
effectivedashboards.com/cours...
👉Article series on creating a maintenance management system data model and how to address the human factors of data collection for improved data quality. (This is not just relevant to maintenance and reliability data).
effectivedashboards.com/data-...