Stacked chart visualization

[Antoine_1976]

First of all, please be patient since I'm new using PBI.

My problem is regarding the visualization of data in a stacked chart.

I've got the following table:

I need a column for each Fase y Denominación. I need each column made for several blocks (like ST 050.000) and respecting the same order shwn in the table.

When I try to make this chart PBI adds CT column using Disp./Assy./Man. values, I mean column has only 2 blocks, 1 for Assy. which is 6,6 and another one for Man. which is 16,2.
I hope I have been clear when explaining what I need (sorry for my English) and thank everyone in advance for your support.

[rajendraongole1]

Hi @Antoine_1976  - No worries! You're explaining it clear.

can you check the format pane, 

Axis (X-Axis) → Select "Fase y Denominación" (this will create one column per category).

Values (Y-Axis) → Select "CT" (this determines the height of each stacked block).

Legend (for stacking) → Select "Disp./Assy./Man." (this will split each column into stacked segments).

Click on the chart, then go to More Options (⋮) → Sort By → Fase y Denominación.

If it doesn’t appear in the correct order, go to Model View and set a custom sort order using an Index Column.

Make sure "CT" is set to SUM in the Values field.If it's showing only two segments (one for "Assy." and one for "Man."), check your data model.

Try the above suggestions and let know.

[Antoine_1976]

Once I tryed you proposal I've got this chart

I've already include a new column in my datasource sheet as #indice (which is simply a number sequence, see below)

Línea	#indice	Fase y Denominación	CT	objetivo CT	Disp./Assy./Man.
Estator BRM Gen2	1	ST 050.000	1,4	24,0	Aut.
Estator BRM Gen2	2	ST 050.000	16,0	24,0	Man.
Estator BRM Gen2	3	ST 050.000	3,8	24,0	Aut.
Estator BRM Gen2	4	ST 050.000	0,2	24,0	Man.
Estator BRM Gen2	5	ST 050.000	1,4	24,0	Aut.
Estator BRM Gen2	6	ST 050.100	22,2	24,0	Aut.
Estator BRM Gen2	7	ST 060.100	11,8	24,0	Man.
Estator BRM Gen2	8	ST 060.100	8,0	24,0	Man.
Estator BRM Gen2	9	ST 060.100	6,7	24,0	Man.

 The only way I've found for splitting the column was to use #indice as Legend but with the every block of the column is coloured different

[Anonymous]

Hi All,
Firstly  rajendraongole1 thank you for your solution!

And @Antoine_1976 ,Can you tell me what kind of effect you want with your new #indice addition?
If you feel that the color of your first Aut and Man is not enough to distinguish, you can choose a brighter color for them in the column in the visual, as shown in the picture below, if you want to use indice to distinguish this is not the right indice, because using it to distinguish the stacked blocks will lead to color confusion, and can't be clearly distinguished. “Automatic” and ‘manual’.

If you want to use indice to realize other needs, you can contact me at any time, I will receive the message the first time to reply to you, I hope my answer can help you!

Hope it helps!

Best regards,
Community Support Team_ Tom Shen

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

[Antoine_1976]

Thank you for your answer.

Is not about the colours but the sequence. I need the segments to be stacked following the sequence not added by Man. or Aut. and with the same colour for Man. and the same for Aut.

I mean, for ST 050.000 column I need an Aut. segment for 1.4 then another segment for 16.0 after that another one for 3.8 (same color that 1.4 segment) now a segment for 0.2 (same colour that 16.0 segment) and finally another one for 1.4 (which is the 5th listed in the table with the same colour that previously 1.4 and 3.8 segments).