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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Ada_nnaya
Frequent Visitor

Multi-row column chart

Hi all, 

I am trying to recreate a chart that looks like the below image. I want each row to show a column chart of the monthly sales of one product. All the y-axis are "connected" ie. I only have one visual but each y-axis if dependent on the sales amount of the each product. 
Using small multiples on the Power BI column char is not quite right as I get the product rows next to each other.

 

Do you know of a visual that can generate the below chart or what such a visual is called?

Ada_nnaya_0-1683555115011.png

Tagging super people for help,  thanks in advance  @tamerj1@FreemanZ , @amitchandak 

 

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

In this scenario you may want to keep the time axis together and use small multiples per product, arranged vertically.  You may want to experiment with a line chart for less clutter.

View solution in original post

2 REPLIES 2
Ada_nnaya
Frequent Visitor

Thank you so much for your response! I can't believe I missed the customisation of the small multiples. 🙂

lbendlin
Super User
Super User

In this scenario you may want to keep the time axis together and use small multiples per product, arranged vertically.  You may want to experiment with a line chart for less clutter.

Helpful resources

Announcements
September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Top Kudoed Authors