Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
ClaimQA122333
New Member

Continuous Multi-Variable Timeline Graph

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. 

 

ClaimQA122333_0-1603121501392.png

 

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):

ClaimQA122333_1-1603121989649.png

 

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!

 

1 REPLY 1
lbendlin
Super User
Super User

Assign your animals an index, and then use the index as the y axis.

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors