Forum Discussion

Renit's avatar
Renit
Frequent Visitor
10 months ago
Solved

Alternative for clustered bar chart

I currently have a sample visual showing Dealers,Franchise, Consultant, and Total Sold on the X-axis, with Product Value or Value % on the Y-axis, and a Category legend — displayed as a clustered column chart.

I’m looking for alternative, more expressive visual options to represent this data — preferably custom visuals that don’t require filters on the screen, since the report will include a print option.

powerbi
  • grazitti_sapna's avatar
    grazitti_sapna
    10 months ago

    Hi Renit ,
    You can opt for other options listen below:- 

    1. Grouped or Stacked Bar Chart (Horizontal)

    • Think of it as the same data, but shown sideways.

    • Easier to read labels (especially long ones like “Franchise” or “Consultant”).

    • Great for printed reports because everything fits better on one page.

     2. 100% Stacked Column Chart

    • Instead of showing raw numbers, it shows percent contributions (so you can compare proportions).

    • Example: You can see what % of total value each category contributes.

    • Useful when comparing relative performance.

    3. Small Multiples (Mini Charts)

    • Shows a separate small chart for each group (Dealer, Franchise, etc.) side by side.

    • Each small chart focuses on that one category, making it easy to compare shapes and trends.

    • It looks cleaner and is great for printing.

    Let me know if you are looking for more option but above three would go perfect with your specifics. 

     

    🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.

    💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.

    🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.

    🔗 Curious to explore more? [Discover here].

    Let’s keep building smarter solutions together!

6 Replies

  • grazitti_sapna's avatar
    grazitti_sapna
    Icon for Super User rankSuper User
    10 months ago

    Hi Renit ,
    You can opt for other options listen below:- 

    1. Grouped or Stacked Bar Chart (Horizontal)

    • Think of it as the same data, but shown sideways.

    • Easier to read labels (especially long ones like “Franchise” or “Consultant”).

    • Great for printed reports because everything fits better on one page.

     2. 100% Stacked Column Chart

    • Instead of showing raw numbers, it shows percent contributions (so you can compare proportions).

    • Example: You can see what % of total value each category contributes.

    • Useful when comparing relative performance.

    3. Small Multiples (Mini Charts)

    • Shows a separate small chart for each group (Dealer, Franchise, etc.) side by side.

    • Each small chart focuses on that one category, making it easy to compare shapes and trends.

    • It looks cleaner and is great for printing.

    Let me know if you are looking for more option but above three would go perfect with your specifics. 

     

    🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.

    💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.

    🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.

    🔗 Curious to explore more? [Discover here].

    Let’s keep building smarter solutions together!

  • Murtaza_Ghafoor's avatar
    Murtaza_Ghafoor
    Icon for Super User rankSuper User
    10 months ago


    You can try these visuals they are the best alternate 

    Lollipop or Dumbbell Chart     – highlights differences cleanly.
    Small Multiples – separate mini-charts for each role (Dealer, Franchise, etc.).
    Matrix with Data Bars – clear numeric and visual comparison.
    Ribbon Chart – shows ranking or dominance changes

  • v-prasare's avatar
    v-prasare
    Icon for Community Support rankCommunity Support
    10 months ago

    Hi Renit,

    We would like to confirm if our community members answer resolves your query or if you need further help. If you still have any questions or need more support, please feel free to let us know. We are happy to help you.


    Praful_Potphode, Murtaza_Ghafoor& grazitti_sapna ,Thanks for your prompt response

     

     

    Thank you for your patience and look forward to hearing from you.
    Best Regards,
    Prashanth Are
    MS Fabric community support

    • v-menakakota's avatar
      v-menakakota
      Icon for Community Support rankCommunity Support
      10 months ago

      Hi Renit ,
      Thanks for reaching out to the Microsoft fabric community forum. 

       

      I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you.

       

      Best Regards, 
      Community Support Team