Chart Templates - EXPLORATIONS IN DATA STORYTELLING WITH POWER BI

Power BI
How To Make ELEGANT In Page Navigation With Power BI Bookmark Navigator
In this video, I’m going to show you how to make a very attractive in-page navigation in Power BI using BOOKMARK NAVIGATOR. Follow the steps and let’s learn how to make this awesome feature. ExcelFort - YouTube Hope this article/video was helpful to you? Please leave your comments, suggestion...
Turn ON-OFF Tooltips In Power BI - Goodly
Turn ON and OFF tooltips with a button in Power BI Reports
How to add MapBox Basemaps to Icon Map for Power BI — DiscoverEI
In this short video blog we walk through how to create custom basemaps in MapBox and integrate them into your Icon Map in Power BI! We then take it to the next level by configuring dynamic basemaps which we can change using slicers. A big shoutout and thanks to James Dales for creating this awesome
Customize Data labels format
Data Masking for Sensitive values
Adding Weather Forecast in Power BI using Azure Map
Azure Maps is a Microsoft technology that has a lot of cool features. Somewhat unexpectedly I discovered that along with purely mapping stuff it also provides functionality to acquire weather forec…
Deep Dive into InfoRiver Export to Excel
This is a further article in my series where I share with you what I have learnt about the InfoRiver custom visual. As good as Power BI is, it will take Microsoft many more years to make it fully featured. Microsoft Excel is 37 years old, and I can assure [...]Read More »
Highlight values, Smart narrative, Great Power BI storytelling technique
I just tested the technique shared by Ruth from Curbal, using the smart narrative to do storytelling in Power BI in order to to catch the user's attention and deliver insights more effectively. The goal is to highlight the selected categories. In a bar chart it's easy since it includes conditional formatting allowing to do it flexibly.
PowerBI Custom Chart Ranges
My go to progress dashboard calculates a lot of progress % metrics and graphs. However for larger projects, its often difficult to zoom into the graph. This is exactly why slicers exist
Thinking about target bands - EXPLORATIONS IN DATA STORYTELLING WITH POWER BI
I’ve come across many charts like this in the wild. They’re not bad charts, they serve a purpose, but they could be better. Bar charts are created by encoding data by length. It is commonly thought that when people read bars, they are comparing length, not position. The axis starts at 50%, rather than zero,… Continue reading Thinking about target bands
How To SWITCH Power BI TOOLTIP PAGE | Made EASY With Bookmark Navigator
Using the bookmark navigator, I will show you how to let your users choose what is displayed on the tooltip according to their preferences. By using this approach, you are able to switch easily between different tooltip pages without having to create multiple tooltip report pages SUBSCRIBE AND WATC...
Position with PureViz - EXPLORATIONS IN DATA STORYTELLING WITH POWER BI
Infographic with PureViz modifying position and percentage fill
Deneb: An Alternative Approach for Custom Visual Development
In this session, Daniel will introduce you to the Vega-Lite language via Deneb - a custom visual for Power BI.
Power BI + Adobe = Magic - EXPLORATIONS IN DATA STORYTELLING WITH POWER BI
Adobe Illustrator has been a tool in my dashboard design kit for quite a while. I’ve used it predominately for creating report assets such as icons, headers and backgrounds. I’ve also used it to create SVG visual elements such as the dice, turbine and scatter plot shapes and markers pictured below. But there’s another way… Continue reading Power BI + Adobe = Magic
The Three Mental Models Model for Data Visualization
A useful way to think more holistically about how data visualization works
Viridis color palettes in Power BI theme files
I am a fan of the viridis color palettes available in python and R, so I decided to make Power BI theme files for each of the 4 color maps (viridis, inferno, magma, plasma). These color palettes ar…
Material Palette - Material Design Color Palette Generator
Choose your favorite colors and get your Material Design palette generated and downloadable.
Examples
An Open Source collection of Design Principles and methods
Setting up an environment for developing a Power BI visual - Power BI
This article explains how to set up your environment so that you can develop a Power BI visual.
PureViz Infographic for Power BI
PureViz Infographic custom visual allows turning your creative ideas into super-fast & animated Power BI visuals. Start from Power Point and bring your data to life!
Create Microsoft Power BI Custom Visuals Interactively | PBI VizEdit
Create Power BI custom visuals with PBIVizEditBuild your Power BI custom visuals easily under 15 minutes with mouse clicks without any coding. Only pay for visuals when you are satisfied with the …
Customise small multiples in Power BI
easily compare different categories on the same axes
Fundamentals of Data Visualization
A guide to making visualizations that accurately reflect the data, tell a story, and look professional.
Set Power BI Data Color: All Visuals to Follow Same Color for the Same Data Point
Learn how you can set the same color for the same data value across multiple visuals and pages in a Power BI report using examples.
Beyond Precision: Expressiveness in Visualization
Using precision as guidance for visualization design is powerful and yet limited in many different ways. Expressiveness may help.
Visualization is about mapping data values to visual channels;
While precision is a useful factor to keep in mind, it’s neither sufficient nor necessary to create effective visualizations.
First, it’s not always true that visualizations that use position are “better” than those that do not. Second, position can be expressed in multiple ways, so the guidelines leave us unable to discern between visualizations that use position differently.
The problem with guidelines based on precision is that visualization is not really about precision.
But visualization is less about precision, and much more about what the visual representation expresses.
data contains information that we want to communicate, and that information is what we want to “express” with visual representations
Good visualizations stem from a good matching between what we want to express and what the visual representation expresses (something highlighted in the foundational work of Jock Mackinlay, who I believe introduced the term in the first place).
Expressiveness is much more about finding a good match between visual properties and “concepts” than precision or accuracy.
diverging color scale is not a matter of precision or accuracy (in fact a diverging color scale may even be less precise!), it’s a matter of good semantic matching; a matter of expressiveness.
The book divides visual channels into two large groups, magnitude channels and identity channels, according to whether they are more appropriate for quantitative or categorical information. For example, if I want to express a quantity, I shouldn’t use color hue, because humans do not perceive hues as ordered). And if I want to express categories, I shouldn’t use symbol size, because we naturally associate sizes with quantities, not categories.
Let’s look at other things one may want to express. Without any pretense to be exhaustive, here are some examples off the top of my head:
Directionality: can the values be positive or negative? Is there a zero value or a meaningful threshold?
Part-to-whole: do the data objects represent the part of a whole?
Order: are the objects organized in a meaningful order?
Grouping: are the objects organized around a set of meaningful groups
Space/time: do the objects represent space or time or space-time phenomena?
But position expresses information in so many other important ways! Think about position on a single axis versus an orthogonal pair of axes; position in polar coordinates; position on a map; position to express grouping and alignment; etc.
Pursuing expressiveness may ultimately lead to inelegant or irrelevant findings, who knows. But it may also open the doors to a much richer description of how visualization works and to much better guidance.
we have to keep in mind that expressiveness is not only useful in figuring out how to express the information and ideas we want to communicate, but it is equally useful in making sure we do NOT accidentally convey information we did not intend to express.
We can work towards having a better and more complete characterization of what information and concepts we typically want to communicate with data and, similarly, develop a better understanding of what visual properties exist and what they express.
The more granular we go, the harder it is to generalize. In addition to that, the impulse to be able to describe every possible situation may backfire by making things more complicated than they need be.
Once we have a better description of data concepts and visual features, how do we build guidelines that can help people think more productively about visualization design?
Finally, if we want to approach this problem scientifically, we will also need to verify that guidelines and models based on expressiveness have a measurable impact on visualization effectiveness. For instance, it would be useful to explore if, among two competing visual representations, the one having a better match in terms of expressiveness leads to a difference in comprehension (which is not easy to measure, but that’s a different story).
We do not visualize data, we visualize ideas based on data, and we need a better mental model (and maybe even a theory) to design visualizations.
Why Shouldn't All Charts Be Scatter Plots? Beyond...
A central concept in information visualization research and practice is the
notion of visual variable effectiveness, or the perceptual precision at which
values are decoded given visual channels...
About that weird Georgia chart
Visualization social media has been busy mocking the following char t by the Georgia Department of Public Health. Pay attention to its horiz...
P110 mackinlay
Asking the right data questions and asking the data questions right
In my last post I lamented the fact that there is too little focus on data thinking in data science and data visualization, and I described how much of a struggle it’s been for me to figure out how to learn and teach these skills. When I teach my academic visualization course, the thing the most exemplifies this need is the way I struggle to teach how to formulate good
Building (Easy-To-Adopt) Software while Doing Visualization Research
Should Ph.D. students focus more on building software people will use?