Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hello everyone! I am super new to Power BI, and therefore if what I ask is nonsensical or impossible, please forgive my ineptitude.
I am currently trying to see if Power BI will be able to help me simplify a lot of my work products that are currently done in Excel, but am running into some problems already.
For background: I measure file performance using 12 different categories, and want to show a continuous performance timeline for each of my file owners. To do that, however, I cannot find the right type of graph/plot. So before I launch into the actual data, I'll simplify it down for example's sake.
I created an example with dummy data to visualize what I mean.
Let's assume that the file is called "Animals I've Seen This Year" and the categories are the animals. I can get the data to display showing "number of animals" on the Y axis (which I want to change) and "month" on the X axis (which is good).
My question is, is it possible for me to show "animal type" on the Y axis, keep "month" on the X axis, and show the bubbles as a fluctuating line for the duration of the graph? I know that "animal type" dictates the color of the bubbles, and "number of animals" dictates the size, but is there a way for me to show this data without the bubbles overlapping?
Something like this (forgive the crudeness of MS Pain):
I suppose this is a bit of a specific request for a graph, but my knowledge in this field is very lacking so it may actually exist.
Thank you to anyone who can help!
Assign your animals an index, and then use the index as the y axis.
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 58 | |
| 45 | |
| 40 | |
| 21 | |
| 18 |