Power BI Blog: Mekko Chart (cont'd)
18 July 2019
Welcome back to this week’s Power BI blog series. This week, we continue with Mekko Chart.
Last week, I created a Mekko chart with data shown in two dimensions, which allows easy and quick comparison between multiple variables:
![](http://sumproduct-4634.kxcdn.com/img/containers/main/blog-pictures/2019/power-bi/mekko-chart/image6.png/23912d3b1671861e02bebcd5183f1607.jpg)
I would like to do some further editing works on this chart. I go to ‘Format’ mode. Here I can sort the data legend by descending order:
![](http://sumproduct-4634.kxcdn.com/img/containers/main/blog-pictures/2019/power-bi/mekko-chart/image8.png/b9ee28d90e6b5bc92ea4aeafdad51628.jpg)
We can see the legend line has been changed:
![](http://sumproduct-4634.kxcdn.com/img/containers/main/blog-pictures/2019/power-bi/mekko-chart/image9.png/0485ccbc83bdeec1d741bad442a1ea5f.jpg)
I want to try sorting the data series by descending order too:
![](http://sumproduct-4634.kxcdn.com/img/containers/main/blog-pictures/2019/power-bi/mekko-chart/image10.png/daf8c4f0259ce428269c0d3d4badd32b.jpg)
It turns out a little messy so I will remove this sort:
![](http://sumproduct-4634.kxcdn.com/img/containers/main/blog-pictures/2019/power-bi/mekko-chart/image11.png/22c6daeb82d7d69ac88f878227e04b28.jpg)
I also want to change the colours of legends to match with my organisation’s colour scheme, by clicking on ‘Data colors’:
![](http://sumproduct-4634.kxcdn.com/img/containers/main/blog-pictures/2019/power-bi/mekko-chart/image12.png/a1537847463e660a31158c8032525438.jpg)
I add the title for the chart as well:
![](http://sumproduct-4634.kxcdn.com/img/containers/main/blog-pictures/2019/power-bi/mekko-chart/image13.png/917da985be13220165c8d2823e95344f.jpg)
Next, I try putting data labels in place:
![](http://sumproduct-4634.kxcdn.com/img/containers/main/blog-pictures/2019/power-bi/mekko-chart/image14.png/8c3be7af9f73d031acae69ed85a2e148.jpg)
However, it turns out that I don’t like many numbers to be displayed on my chart:
![](http://sumproduct-4634.kxcdn.com/img/containers/main/blog-pictures/2019/power-bi/mekko-chart/image15.png/e63c0a4c21afc9afb438aacc09a59317.jpg)
Therefore, I remove the data label, and here is the final product of my creation today:
![](http://sumproduct-4634.kxcdn.com/img/containers/main/blog-pictures/2019/power-bi/mekko-chart/image16.png/d082e3477129350b8a2a589156028e63.jpg)
That’s it for this week, check back next week for the next blog in the Power BI series.