This week we are familiarising ourselves with Charticulator and Nested Charts.
This graph was inspired by Gus Wezerek and Sara Chodosh’s chart for NYT Opinion.
- Download the data and remove all columns excepting the Date field, New Cases Smoothed Field and Location (save as csv)
- Create a second csv with only Location = High Income data. Ensure the dates are American format (YYYY-MM-DD)
- Launch Charticulator in your browser and load the High Income data
- Add a rectangle mark to the glyph area, ensure it snaps to grid
- Link the fill colour of the rectangle mark to “New Cases Smoothed” data
- (Optional) To create an area chart, link the rectangle marks using bands and set the width of the rectangle to 0.5.
- Link the height of the rectangle mark to “New Cases Smoothed” data
- Link the X-Axis of the plot segment (not the glyph) to the Date field
- Link the Title Text to the Location Field
- Export the visual as a Charticulator TEMPLATE
CREATE NEW CHART
- Create New Chart with the same csv data
- On the Plot Segment, Group By Location
- Drag the Nested Chart option into the Glyph Area
- In the Nested Chart options select Import Template
- Import the Charticulator Template from the previous step 9
- Size the Nested Chart to 200 by 400 and adjust the Chart Area to fit (or leave blank for auto-sized charts)
- Export as Power BI Custom Visual
OPEN POWER BI DESKTOP
- Create a new Power BI Desktop file
- Import the csv from step one
- Filter the data to only the income locations, remove unnecessary columns
- Import Power BI Custom Visual into Power BI Desktop
- Drag the fields into the Custom Visual
- Create a spiral plot
After you finish your workout, share on Twitter using the hashtags #WOW2022 and #PowerBI, and tag @JSBaucke, @MMarie, @shan_gsd, @KerryKolosko, and @NerdyWithData. Also make sure to fill out the Submission Tracker so that we can count you as a participant this week in order to track our participation throughout the year.