Forum Discussion

Antoine_1976's avatar
Antoine_1976
New Member
1 year ago

Stacked chart visualization

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.

Need Help

4 Replies

  • rajendraongole1's avatar
    rajendraongole1
    Super User
    1 year ago

    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's avatar
      Antoine_1976
      New Member
      1 year ago

      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#indiceFase y DenominaciónCTobjetivo CTDisp./Assy./Man.
      Estator BRM Gen21ST 050.0001,424,0Aut.
      Estator BRM Gen22ST 050.00016,024,0Man.
      Estator BRM Gen23ST 050.0003,824,0Aut.
      Estator BRM Gen24ST 050.0000,224,0Man.
      Estator BRM Gen25ST 050.0001,424,0Aut.
      Estator BRM Gen26ST 050.10022,224,0Aut.
      Estator BRM Gen27ST 060.10011,824,0Man.
      Estator BRM Gen28ST 060.1008,024,0Man.
      Estator BRM Gen29ST 060.1006,724,0Man.

       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's avatar
        Anonymous
        Not applicable
        1 year ago

        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.