Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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?
Solved! Go to 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.
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
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
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.
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?
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
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
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.
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
@Anonymous , see if this visual can help
https://appsource.microsoft.com/en-us/product/power-bi-visuals/wa200001934?tab=overview
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
145 | |
79 | |
63 | |
52 | |
47 |
User | Count |
---|---|
217 | |
89 | |
76 | |
67 | |
60 |