Bitcoin What-If Calculator & Regulation News in Power BI – Detailed Version

Some people will say that 2017 was the year of the Bitcoin. Whether you have invested in cryptocurrency or not, here is a Power BI tool to play with different What-If scenarios. Select the initial invested amount, set the buy and sell dates, and enter into the time machine to become a millionaire. Click on a date, on the bar chart, to find out which regulation news were published on a specific day, or click the News bookmark to expore the Bitcoin news in 2017.

You can download the pbix file here, and if you like it, please click the Like button, to give Kudos.

Here are several useful elements you can learn by downloding the report:

  • How to connect to a Web Rest API (Coindesk) to get the current Bitcoin (Coindesk BPI) price and historical data.
  • How to split text into words, and load them into Word Cloud visual.
  • How to create the measures that are necessary for the What-If logic.
  • How to use a timeline, and toggle between two visual effects: Highlighted period, or zoom in.
  • Bookmarks are also used to flip between two pages.

This submission is my first out of three submissions for the “Year in Review” contest. Learn more about the contest here.

Used Data Sources:

1- Bitcoin regulation news dataset was obtained from who mine the web for news, blog posts and online discussions, and allowed me to export all media news on Bitcoin regulation in 2017 from the top 1000 ranked websites.

The data is vailable here:

The Zip files were extracted manually to a folder. Power BI was used to append all json files.

2- Bitcoin historic prices are loaded from Coindesk:

If you have friends who are addicted to the fluctuations of Bitcoin, please share this blog post with them. The embedded report is auto-refreshed 8 times a day. They can just keep watching 🙂

Update (Jan 26, 2018):

  • This report was featured by Power BI team here.
  • My second submission to 2017 Year-in-Review contest can be found here.


  1. Giang Reply

    I really like your idea and report. I also like the fact that I can learn from your report. However, i got stucked from the very first step which is getting data from API web (the link you provide) to my power BI desktop. I use web option as the method to get data. Could you help?

Leave a Reply