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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors