The 10th anniversary of Power BI is a unique opportunity to express our passion for this tool and our gratitude to all those involved in its continued development.
Power BI is not only great at connecting data, it also connects people, in many cases significantly impacting their professional careers or just personal lives.
Personally, I love DAX, I love Power BI, so I just had to take part in this amazing initiative.
After all, a 10th anniversary only happens once!
Besides, I was very curious about how different people would present very similar data. What path they would take, and how creative they would be in data visualization.
The judges will definitely have a lot of work😊
I would appreciate any feedback.
(report will be embedded later, so below you can see some screenshots).
Submission
My entry is a combination of a classic dashboard and data storytelling about the adaptation of communication technologies in the second decade of the 20th century (I used slightly different data than that provided on the competition home page).
Entry consists of three main sections:
- Overview – a bigger picture with global trends and in-depth analysis of financial indicators
- Technology section (4 pages) – allows to see more details about a given technology and compare data through other dimensions
- Summary – key insights (fastening everything together)
Layout
The appearance and layout of all pages is consistent and maintained in the same color pallete.
The elements are arranged with the greatest care, every little detail has been taken care of.
Help tooltips
Most of the report elements contain additional information, hover over the question mark icon to get details.
Titles and subtitles
Particular attention was paid to titles and subtitles.
The titles of charts, tables and maps change dynamically, depending on the user's selection.
The subtitles contain interesting informations, it is worth to followe them carefully.
Things you might especially like
Maps / Locate Top Country button - all maps are filled with gradient (the darker the color, the higher the value is). In many scenarios the country with the best result is very small and invisible on the world map, so using the „Locate Top Country” button you can go directly to the country with the highest value.
Line chart / Choosing additional lines – in each technology’s page you will find a line chart (located in the central area of the page) with light blue "+" symbol. After pressing it, a menu appears with the option to select additional lines (trend line and YoY growth).
Tables / dynamic context change - in each technology’s page you will find a table (located in the lower right corner of the page). When there is only one Continent selected on the dedicated slicer, the table shows top 5 countries in each continent. Otherwise the table shows the Top 1 country in each continent, according to the indicator.
Area chart / custom tooltip – in each technology’s page you will find an area chart (located in the upper right corner of the page). At this moment, when you add a legend to the chart, there is no possibility to sort the legend by Value, so the default tooltip is hard to read (especially when there is more than 4 elements).
That’s why I created custom tooltip, that gives the user a clear picture of the data distribution and also includes additional information.
Note: you can switch between Continet or Country view, tooltip adapts to the context.
I used only native visuals, pure PBI and DAX.
Hope you enjoy my submission.
#pbi10
Some screenshots
