YouTube video in English | YouTube video in Russian | Article in Russian

From time to time I challenge myself to imitate creative vizualizations I stumble upon on the vast expanse of Internet using only standard visuals in Power BI. So this article is all about one of those challenges.

Having found the chart below, I started thinking how one can create a pie chart where slices differ not only by sector width but by its length as well, if it is allowed to put it like that.

Source of inspiration

And I did find a way. 

Final result

Recently, I came across a requirement where I had to display hierarchy data. Lower levels of data should be shown as a ratio of all the segments available rather than a ratio in its own group. Also, some multiplication factors need to be applied. In addition, hierarchy needs to be summed up from lower levels instead of grouping and rolling up. Below article describes how set up the calculation and data.