Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
02-20-2025 15:47 PM - last edited 02-22-2025 10:33 AM
This Power BI report presents a visual analysis of same-sex marriage legislation across different countries. Using two datasets, it highlights the legislative status over time and provides insights into the global trends.
To improve geographic representation, I developed a custom topology for the Shape Map. Unlike the default Filled Map, this version allows for background removal and greater customization. The entire world projection was created using Natural Earth Data and Mapshaper.org, with some small refinements like removing Antarctica to optimize space usage.
Since this is a visualization competition, I created custom color theme to enhance clarity and accessibility. The base colors are derived from the IBM Design Library, ensuring a colorblind-safe palette. Additional colors were selected from Paul Tol's schemes, closely aligning with the Mako gradient for a cohesive look. (source: Colorblind Safe Color Schemes). I wanted to use dark theme background bacause everyone loves using dark modes more, right? I added white labels and text for high-contrast and better readability.
To further personalize the report, I used Visual Basic Studio to integrate custom conditional formatting icons, converting PowerPoint icons into Base64 format and saving these to theme json. These icons, alongside custom navigation buttons, enrich user interaction.
A dedicated trend page visualizes the historical growth in the number of countries legalizing same-sex marriage, offering a clear perspective on global legislative progress.
I hope you like it!
eyJrIjoiYWQ5YjlhY2EtMDliMy00YWIwLWEwYjYtOWMyZjFmZTJhZGRlIiwidCI6IjY2NjE5MTlhLThmMTQtNGRjMi1iMjQ4LTdkMWY2YmUwNTkxNiIsImMiOjF9