Get CoinMarketCap API
Launch Power BI application –> Import Data from Web.
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!
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!