Skip to main content

Power BI

Under Review

Clustered+stacked Chart

Vote (1896) Share
Wenchang Han's profile image

Wenchang Han on 05 Dec 2014 10:31:11

A column/bar chart with both clustered and stacked features (stacked clustered bar/column chart).

http://www.originlab.com/doc/en/Tutorial/images/Clustered-Stacked_Column_Chart/Clustered-Stacked_Column_Chart.png

Comments (219)
Wenchang Han's profile image Profile Picture

e02777a6 c135-411c-82ee-bdc182baf22f on 05 Jul 2020 22:53:24

RE: Clustered+stacked Chart

For me, this request is a basic functionality for a BI tool. It's embarrassing that I have to go back to MS Excel to create this visual.

Wenchang Han's profile image Profile Picture

9d5b5738 d2df-4ed5-9cd8-140e00ffe54e on 05 Jul 2020 22:49:57

RE: Clustered+stacked Chart

I have spent the entire day trying to figure out how to do this after it was reuired. I can't understand why it has been requested for 2 years and now we are paying for this product lacking things that seem pretty basic...

Wenchang Han's profile image Profile Picture

2ac24fa8 2e27-4920-91a6-aecca54cfb8d on 05 Jul 2020 22:49:23

RE: Clustered+stacked Chart

I agree this should be a out of the box chart which is available.

Wenchang Han's profile image Profile Picture

2054d609 51ca-4b32-93c9-4488003d6a66 on 05 Jul 2020 22:49:04

RE: Clustered+stacked Chart

I agree completely - I need this - very important. Need to be able to compare a number of items. I'm trying to have cost for a period of months and compare in the bar chart of a number of account types. This is definitely possible in Excel. Should be out of the box.

Wenchang Han's profile image Profile Picture

dcdb98b0 9950-4af2-a747-d5638d297ed2 on 05 Jul 2020 22:48:55

RE: Clustered+stacked Chart

Zoomcharts has this now in a purchasable visualization. You can find it in the Microsoft store. You can use the Advanced Column, Line, Area chart. The paid version allows up to 9 series. Unfortunately I need 12 series (3 bars in a cluster with 4 stacks each). But, it got me close... Maybe it will fit your needs.

Wenchang Han's profile image Profile Picture

b5ebdfa0 b9ac-434a-bfff-38a1c9ea86a6 on 05 Jul 2020 22:48:42

RE: Clustered+stacked Chart

This feature has been under review a long time. This should be an out of the box feature. Users say "this is possible in Excel...why not in Power BI"?

Wenchang Han's profile image Profile Picture

9b36bebf 7463-41e5-a806-a96e3c01b8ab on 05 Jul 2020 22:46:02

RE: Clustered+stacked Chart

This seems very basic and required!

Wenchang Han's profile image Profile Picture

2d4ca957 a413-47eb-b0ea-253e09d27e12 on 05 Jul 2020 22:45:41

RE: Clustered+stacked Chart

Comparing percents of breakdown (stack) clustered is crucial in retail analytics, e.g. sales breakdown vs. inventory breakdown right on top of or next to each other!

Wenchang Han's profile image Profile Picture

9ce286a5 f4fa-4ca9-b2c2-429fbcccb66b on 05 Jul 2020 22:45:18

RE: Clustered+stacked Chart

Lack of this feature is a major drawback. Hope its made available soon.

Wenchang Han's profile image Profile Picture

449d3cc1 bbb1-4d7b-9ccb-06bd4025e66e on 05 Jul 2020 22:43:54

RE: Clustered+stacked Chart

We need the feature urgent