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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

Top Solution Authors