2021 Week 35 | Power BI: Infographics | My Attempt
Data Scrapping As stated in the notes Data scrapping is the most challenging part of this weeks challenge. 2 data sources given in the challenge. I created excel table with scrapped data from coffee affection website and imported it to the Power Query Editor with given Excel table. Step 1 - First Draft Before I jump into Pure viz custom visual as instructed in the challenge I thought I should figure out how this should be done with classic visuals. This is the first draft I created using 5 card visuals and slicer. I wanted to get the colors and order correct. So I created draft with already available visuals. In the middle there are 4 card visuals, each has ingredient color set as background and ingredient name as card value. Ingredient 1 in the bottom an Ingredient 4 on the top. 5th card contains the description. Slicer contains Drink names. There is a little issue with this. For Drinks with less than 4 ingredients it shows (Blank) on the card instead of empty card. To fix this I us