Archive for July, 2019
How to conditionally format visuals in Power BI?

Do you know that you can apply conditional formatting rules to visuals in Power BI? In this post, let’s learn how to conditionally format visuals in Power BI. Something like this:
Continue »Tour de France – Distance & Pace over time – Radial Charts

This is an Excel replica of excellent Tableau visual on Tour de France winner data made by Marc Reid.
Last week I saw a stunning visualization on Tour de France using radial charts. I wanted to replicate it in Excel. So here we go.
Continue »Make info-graphics with shape fill technique [Charting Tip]
![Make info-graphics with shape fill technique [Charting Tip]](https://chandoo.org/wp/wp-content/uploads/2019/07/make-info-graphics-in-excel.png)
This is a quick, fun and elegant way to make impressive charts. You can easily create info-graphic style charts in Excel using shape fill technique. Something like this:
Continue »![How to predict cricket scores [Excel + Machine Learning]](https://chandoo.org/wp/wp-content/uploads/2019/07/india-vs-bangladesh-2nd-july-2019-world-cup-game-predictions-vs-actual.png)
Can we predict cricket match score in Excel? Using machine learning, ensemble modeling, multiple regression and Excel formulas we can. This tutorial explains how.
Continue »