Forum Discussion

Renit's avatar
Renit
Frequent Visitor
11 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 col...
  • grazitti_sapna's avatar
    11 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!