Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Stacked chart

Hi guys, 

I have this data,

and trying to set a stacked bar chart, however i would like to stack the data by value without the aggregation, all i got is this, 

 

how can i stack the data by index secuence and without aggregating the values? i need the 21 rows stacked.

 

Thanks

Need Help

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Anonymous 

     

    Click the bustton as shown in picture and check the options which can be used. Do you have "Don't Summarize" use it.

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi Anonymous ,

      Thanks for your time, 

       

      none of this options work to accomplish what i need 😞

       

       

    • parry2k's avatar
      parry2k
      Super User
      6 years ago

      Anonymous you need to put index column on the x-axis, you have to have an aggregation on the value column.

       

      I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

      ⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

       

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    Anonymous , you can not avoid aggregation, so you have use index either on-axis or legend 

  • v-xuding-msft's avatar
    v-xuding-msft
    Community Support
    6 years ago

    Hi Anonymous ,

     

    Can you please tell us if you have resolved this issue? If yes, please accept the helpful answers as solutions. If you still need help, can you please share your expected result? Thanks!