Archive for July, 2019
How to conditionally format visuals in Power BI?
![How to conditionally format visuals in Power BI?](https://chandoo.org/wp/wp-content/uploads/2019/07/howto-conditionally-format-visuals-in-Power-BI.png)
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
![Tour de France – Distance & Pace over time – Radial Charts](https://chandoo.org/wp/wp-content/uploads/2019/07/tdf-radial-chart-1.png)
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 »