Clustered Stacked Column chart with individual values stacked

[Anonymous]

Hi,

I am trying to plot the data as shown in fig below.

But I don't see visual for a stacked and clustered column chart. There are two separate visuals for both of them. I need to draw second stacked bar with individual values on top of each other and that compares to the values in first column with single value, something like a comparison of the two columns.

Is there any feasible solution to this in Power BI because in excel you can tweak the two charts types but not here or something that I am unaware of?

[v-easonf-msft]

Hi， @Anonymous 

Sorry,I haven't find  any other custom visual  that meets your requirements  currently. 

I am also a trial user. If you have not used this custom visual before, then when you open the report, you will automatically have the access to the paid features for 30 days.

Please check the following steps:

1) select  the visual to active  it ->  2)select the "format" pane ->   3)select "series 3 Configuration" 
Then you will  find the custom "Stack" settings

Best Regards,
Community Support Team _ Eason

[Anonymous]

That is absolutely fine @v-easonf-msft .

And thanks for your efforts in solving my problem. I really appreciate that.

I did figure it out myself where the stack settings needed to be configured. Thanks again for explaining me the settings in detail here.

You saved my day, you rock :).

If you come to know of any free visual for this kind of problem, please do drop me a line about the same.

Thanks again,

Best Regards,

Nitin

[v-easonf-msft · Accepted solution]

Hi, @Anonymous 

Try custom visual   "Dril Down Combo Pro By ZoomCharts"  .

You need to manually define the format of some fields .

Please check atteched file for more details.

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[mruhullah]

@v-easonf-msft Is this free or paid?

[Anonymous]

Thanks @v-easonf-msft 

That does work. However, this requires a license to purchase its pro features. Further, the custom "Stack" settings you specified, I don't find them in my Desktop opened pbix. It seems that stack settings are again for pro license.

Can it be there any other custom visual that does not require any license purchase?

[Anonymous]

I am attaching my sample pbix so that it can be referenced as to what I am trying to make it as.

The report contains two tabs, "Plot to draw" and "Plot available in PBI". Hope it explains my purpose.

Clustered Stacked Bar Sample PBIX 

[v-easonf-msft]

Hi， @Anonymous 

Microsoft AppSource    custom visual   "Multiple Axes Chart-XViz"   maybe a good choice.

Check sample file for more details.

Best Regards,
Community Support Team _ Eason

[Anonymous]

The problem with this is that you see two different columns with identical set of values viz. "Forecast" vs "Actual" and each split into equal number of stacks. In my case, I have two columns viz. "Committed" vs "Actual". Where "Committed" column is a single stack while "Actual" column is stacked into three individual bars. Hence, the data plot is not the same. Further, I have a single row for different sprint or Country against each individual values in my table. So, another ggplot2 approach is also not plotting the chart as the way I need it to be.

Looking for some good alternates as of now....any help is appreciated.

[TomMartens]

Hey @Anonymous ,

unfortunately, this is not possible using default visuals, and I'm also not aware of any custom visual that combines clustered and stacked columns charts.

You can use R or Python to create this, here is a link with examples using R:

https://thetablebar.blogspot.com/2019/11/stacked-bar-chart-ggplot2-r.html

Hopefully, this provides you with some ideas.

Regards,

Tom

[amitchandak]

@Anonymous , see if this visual can help

https://appsource.microsoft.com/en-us/product/power-bi-visuals/wa200001934?tab=overview