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.

avatar user

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)