Crypto Treemap
Requirement
Today we will see how to do our own portfolio with CoinMarketCap data and visualize it with Power BI.
To do so please create an account in https://pro.coinmarketcap.com/account and get your own API Keys.
Install PowerBI Desktop in Google store or download it here .
Get CoinMarketCap API
Launch Power BI application –> Import Data from Web.
Enter https://pro-api.coinmarketcap.com/v1/cryptocurrency/quotes/latest?symbol=YOUR_COIN&CMC_PRO_API_KEY=xxx
For example: https://pro-api.coinmarketcap.com/v1/cryptocurrency/quotes/latest?symbol=BTC,ETH,EGLD,LINK,CHSB,AVAX,DOT,XTZ,UNI&CMC_PRO_API_KEY=YOUR_API_KEY
When you validate you will arrive in the Power Query Editor. First Remove all applied step except Source.
Click On record:
Click on “In table”:
Develop Value and select column in which you are interested in. Develop Value.quote (last column) aswell.
Congratulation you have imported CoinmarketCap Data into Power BI!
Data Visualisation
TreeMap Like Coin360
Choose TreeMap Design
Add some color so you can see quickly if last 24 hours were good for CryptoMarket.
Input your colors as following:
Here is the result!
