Data Visualization Workout 007 - Revenue analysis - various functionalities

Workout 007 – Revenues by business line by customer – various functionalities
Difficulty rating: 4 out of 5

Intro note
This workout combines various visualization techniques. The most important part of the workout is practice - entries does not have to include every element or functionality to be still considered as great . Please pay attention to the list of functionalities (provided in the screenshoot and in published-to-web report), which includes ‘basic’ elements (1st-4th point), supplemental (5th point) and extra (6h - 7th point). I would kindly recommend to review them before executing green and blue points to provide proper plan and flow of your work.

A good starting point is to implement: titles & headers along with basic KPI metrics (using matrix / table) // picking either line or column chart and replicating with presented functionalities and formats and adding tables without TOPn selection. Realizing further points (blue/yellow) will provide additional technical practice

Following workout bases on exact same data source as provided in workout 002 // workout 005 // workout 006 - if you already participated in one of this two workouts - please feel free to reuse your already transformed datasource / model / measures etc.

**Following workout does not require to use each column. Nevertheless, please feel free to use any columns and any data which is valuable from your perspective. Feel free to use your entries as a part of your project portfolio, if it’s instrumental in realizing your goals.

Additional notes

    1. Total AC = revenues (realization)
    1. YoY change = absolute and relative variance ( ΔPY)
    1. AR (per month) = average revenues per month
    1. AR (per client) = average revenues per customer
    1. Dark markers (in a line chart) and dark-coloured columns (in a column chart) are applied to those data point that display minimum or maximum value or which is the last data point in the selected period
    1. Y-axis unification (“extra step”) refers to the line charts and column charts
    1. Selecting given TOPn customers or including / excluding group “Others” should impact only on the bottom tables (‘Breakdown by customer’). All metrics in the upper section and line/column charts should not reflect the “TOPn selection”.

    1. In order to change views between line and column charts - you can click on blue subtitle (workout header, “Summary card”)


In this workout, using the supplied dataset and reviewing the provided interactive report (link below) we are going to replicate the following set of vizualizations (left section in a report screenshot), including the column charts, scatter chart, table, slicer pane and bookmark navigation experience. Also, please feel free to add any extra visual if you would like to (provided that core visualizations are included in the first place).

007 - Workout - Contractor profitability (revenues).xlsx (110.9 KB)

Core actions (practice) :

    • Creating KPI cards using native matrix / table
    • Adding additional lines and series labels to the line / column charts
    • Applying data highlighting for certain data points (different markers or colors for selected points)
    • Applying custom tooltips (within a charts)
    • Applying custom tooltips as an “object” to provide additional comments for end-users
    • Formatting tables (grids / borders)
    • Making Dax calculations (TOPn and Others // ‘row total’ calculations in a table, etc).
    • Setting appropriate interactions across visuals


Please load the supplied data (xls file) into a Power BI file, replicate visualizations (considerating list of points in the introductory report screenshot and the general design and functionality provided through interactive published-to-web report), and reply to this post including the screenshot (or a gif) of your solution along with the pbix file (please, include name or EDNA forum nick in the pbix name).


This workout is released on Tuesday May 08, 2023, and the author’s solution will be posted on Monday/Tuesday May 15-16, 2023.

Additional materials

Link to the interactive dashboard:


Have a great fun!

Best regards!


Lets go again


wow !
the target look very good.
Let’s do it !


Greetings, It is with great pleasure that I present my submission for Data Visualization Workout 007 - Revenue analysis - various functionalities, albeit still a work in progress. However, I felt compelled to share the portions that have been completed before embarking on my holiday. Without further delay, I submit my work for your consideration. May peace and love be with you all.


Hi! Already looks terrific!! Appreciate your message. Have a great holiday(s)!


Nice work @windler.nikki. Enjoy your holiday!



Once again, this was an extraordinarily well-prepared workout. Complicated but fun, and quite useful.

I still have to wire-up the displays at the bottom to react to the change in “Other bin”. The visuals at the bottom are one of each, TOPn and Others for construction supply and Selected TOPn only for interior design.


Tidying up the easy stuff is more attractive to me at this point than fiddling with bookmarks and field parameters…the tedium is too hard to handle :slight_smile: And I still haven’t made the changes to the rank counts such that, for others, the rank ID has a “>” prefix.

The only thing I added was conditional colors and label values. I added a slicer to choose between min,max/last, YoY, and YoY%, and I used those same colors in the tooltips, the column and points, and the text labels. I also used slightly different colors only because I couldn’t see the differences among min/max/last.


Incredible workout. Well done Gustaw


hi !
great workout ! full of details :wink:
please find attached my file.
ciao !
Workout 007 - Revenue analysis - Roberto Ravani OK.pbix (438.5 KB)


Awesome work Roberto


My submission - some issues to improve, especially in the chart: Breakdown by customers (wrong sum, rank for “others” or bar for “others”) and still issues with chart scale, but finally a lot done :slight_smile:
workout 007c.pbix (105.5 KB)


Awesome work renata

1 Like


Thanks, @Gustaw for another great workout. Lots of tricky elements in this one. Hope I did it justice

Report Link

EDNA Visuals 007.pbix (239.1 KB)


Thank you :slight_smile:


Hello Gustaw, thanks for the workout. You are helping me a lot to improve my skills in Power Bi, along with these challenges I am moving to a new level! I’m really happy about it :slight_smile: :+1:
Workout 007_EDNA_AngelinaMihejenkova

Workout 007_EDNA_AngelinaMihejenkova.pbix (562.5 KB)


Well done everyone, fantastic submissions!


What is a Keyboard shortcut Key for Triangle Symbol. or is there any other method

1 Like

I go to a unicode website and there is usually copy functionality, I then paste into my measure.


Hi you need to install / enable in windows the Greek language. Then Shift + alt to change language and Δ is a capital D


Awesome work