Forum Discussion

SusanaSantos's avatar
SusanaSantos
New Member
6 months ago
Solved

Need a stacked clustered column chart

Hi,  Need to create 3 stacked columns per service stacking the waybound legs,  column 1 YTD, column 2 Budget and column 3 LY the clustered stacked column chart visual only allows 2 columns , I need...
  • Ritaf1983's avatar
    6 months ago

    Hi SusanaSantos 

    Power BI doesn't currently offer a built-in (core) visual that combines both clustered and stacked column charts.

    To achieve this, you have two main options:

    Custom Visuals: Download a specialized visual from the AppSource (as seen in your screenshot). Options like Multi-Axis Chart or dedicated Stacked and Clustered visuals are designed for this exact purpose.

     

    The Workaround: Follow the method in the video. This involves using a standard Stacked Column chart and adding "dummy" blank rows to your data to create the visual gaps between the clusters.

    Both are valid solutions; the choice depends on whether you prefer using a third-party visual or manually adjusting your data structure.

    https://www.youtube.com/watch?v=AI3eT1kRje4

    If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

     

  • tharunkumarRTK's avatar
    6 months ago

    SusanaSantos 

    You can achieve this using Infographic Designer visual, It is developed by Microsoft and its certified by them. The good thing is it is free to use.

     

     

     

     

     

    Connect on LinkedIn

    read my blogs here: techietips.co.in

     

     

     








    Did I answer your question? Mark my post as a solution!
    If I helped you, click on the Thumbs Up to give Kudos.

    Proud to be a Super User!