native Power BI graphics
with just the core visuals…developed by carlos barboza
001: Band Chart on MLB salaries
A basic line chart enhanced with a shaded area displaying the upper and lower boundaries of a group of data or the range between the maximum and minimum of all members of the group. Many thanks to my friend Robert Mundigl for the inspiration of this replica. His blog-post on this underrated chart type is a must read.
002: Small Multiples with first-end markers
Extending the band chart to small multiples for a panoramic view of the salaries of all MLB teams at the same time, along with the option of turning on/off the first – end markers of each individual multiple. Many thanks to Deyvit Jeri and Pedro Castillo from Data Visualization Perú for their help in formulating a DAX measure that places markers when total salaries does not begin from 1985 or ends at 2015.
003: Contextual Band Chart
Enabling contextual analysis by adding a second Teams slicer. The first slicer allows multiple team selections to calculate the min/max/average salaries of those teams. The second slicer lets the user pick one team (e.g., Red Sox) to compare its salaries with the combined stats of teams selected in the first slicer (e.g., Yankees, Cubs, White Sox).
004: World Child Mortality
Combining the powers of a band chart with an interesting metric: Child Mortality Rate, under age five. Let’s add some interactivity like switching the average calculation to median or vice-versa. The technique of disconnected tables is proper for this scenario. Huge thanks to the Gapminder Foundation for making available the dataset for this example.
005: Google's Mobility %
Here combining the band chart with another interesting metric: Google Mobility %. And let’s add some interactivity like switching the field dimension upon which the iterators on the calculations of the average, min and max are based on. On this requirement, field parameters come to the rescue. Huge thanks to Google for making available the dataset for this example.
006: non-adjacent reference bands
Now with error bars, the implementation of adding these bands is quite easy. Bonus: you will also learn about two interesting approaches for writing the formulas for graphing these bands. (site under -reconstruction…)
008: dynamic plot area background
Unbelievable that the options of background area for your visuals in Power BI are so limited. (site under -reconstruction…)
009: User-defined tooltips
User-defined tooltips in Power BI, where the user can switch the graph type of the tooltip for additional context and precision on the information. (site under -reconstruction…)
010: from sharpy lines to dots
Sometimes the high variability or dispersion of a metric on a line chart can create a very sharpy and edgy look. On this post, we present two versions on how to improve this in Power BI. (site under -reconstruction…)
011: Cycle Plots
Also known as seasonal sub-series graphs, or month plot. They can unveil nuanced perspectives, unknown unknowns, and even, multiple truths thru a single and clever layout, showing a great deal of information in a small space without information overload, along with prompting to ask meaningful questions in search of understanding the behavior and impact of the month-of-year effect and cyclical patterns on seasonal time series datasets.
012: (my) Power BI wish-list
A collection of ideas for the interactive visualization engine of the Power BI Core visuals. These have been obtained by observing and analyzing the amazing visualization of other professionals, practitioners, journalists and expert in the field of data visualization.