This trellis chart displays food self-sufficiency rates for 47 Japanese prefectures in FY2019, arranged from highest to lowest across a 10-column grid. Each cell contains a satellite chart — a spiral visualization where one full revolution represents 100% self-sufficiency. The spiral uses color to indicate which century of value is being represented: orange for the first 0–100%, blue for 100–200%, and pink for 200–300%. A hollow dot marks the endpoint of the spiral. The percentage value and prefecture name are displayed in the center of each spiral. Hokkaido leads at 216%, followed by Akita-ken at 205% and Yamagata-ken at 145%. Most prefectures fall below 100%, indicating they produce less food than they consume. Tokyo-to has the lowest rate at 0%.
This week's #Wow2026 for #PowerBI is a Power BI remake of a previous Tableau challenge. We are making satellite charts to show percentages that exceed 100%.
Check it out: www.workout-wednesday.com/pbi-2026-w16/
@shan-gsd.bsky.social @merrykerry.bsky.social