I wanted to create a dashboard to show endangered species. The source was a PDF with three tables, each covering a different category (linked in the first post).
In Power Query I imported the tables, reformatted them into a consistent structure, added a category column, and appended them into one table.
To enable time-based exploration, I linked the dataset to a date table, which drives the time play axis.
The main visual is a stacked bar chart, with categories as the legend and species on the y‑axis, making comparisons across groups straightforward.
For tooltips, I built a separate tooltip page with a line chart, so hovering reveals historical trends without cluttering the main view.
The canvas background was generated with Copilot Designer, and I selected a colour palette that complements it for clarity and aesthetics.
I also added a smart narrative at the bottom. It calculates yearly measures, updates dynamically with the play axis, and provides a textual summary of the trends. The measures can be seen in the file.
I hope this helps? 😊
You can also write me a PM if you have more specific questions.
I'm really happy to hear that you liked my design 🌻
