Bitcoin What-If Calculator in Power BI

Many people will say that 2017 was the year of the Bitcoin. Whether you have invested in cryptocurrency or not, here is your best Power BI tool to play with different What-If scenarios. Select the initial invested amount, set the buy and sell dates, and enter the time machine.

You can download the pbix file here, and learn some neat tricks:

  • How to connect to a Web Rest API (Coindesk) to get the current Bitcoin (Coindesk BPI) price and historical data.
  • 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.

The report supports scheduled refresh.

If you love this report, please give a kudos here. This is my first submission (It’s only a warm up…) for Microsoft Power BI Year-in-Review contest. Learn more about the contest here.

I will update this blog post in the near future, and share the implementation details. But why waiting – Download the .pbix file, and give a kudos if you liked it here.

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 🙂

Leave a Reply