Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

Clustered Stacked Column chart with individual values stacked

Hi,

 

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

 

nitin_bhatnagar_0-1605851955475.png

 

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?

1 ACCEPTED SOLUTION
v-easonf-msft
Community Support
Community Support

Hi, @Anonymous 

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

36.png

 

You need to manually define the format of some fields .

33.png34.png

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.

 

 

View solution in original post

10 REPLIES 10
v-easonf-msft
Community Support
Community Support

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

 

37.png

 

Best Regards,
Community Support Team _ Eason

 

 

 

Anonymous
Not applicable

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
Community Support
Community Support

Hi, @Anonymous 

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

36.png

 

You need to manually define the format of some fields .

33.png34.png

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.

 

 

Anonymous
Not applicable

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

Anonymous
Not applicable

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
Not applicable

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
Community Support
Community Support

Hi, @Anonymous 

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

 

31.png

 

Check sample file for more details.

 

Best Regards,
Community Support Team _ Eason

Anonymous
Not applicable

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
Super User
Super User

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



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany
amitchandak
Super User
Super User

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors