Forum Discussion
Multiple Value Columns in a Stacked Column chart
Could someone advise how I can recreate this excel chart in PBI? I can't seem to add more than 1 value column in PBI. It is relatively simple in excel. Thanks.
I need to see the yearly costs by category in each column.
Anonymous you need to unpivot the data,
transform data -> select id and category column -> right click -> unpivot other data
it will add two columns, attribute and value, rename as you see fit, close, and apply.
now you can use attributes on rows, categories on columns, and value on values and that will do it.
✨ Follow us on LinkedIn and to our YouTube channel
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to 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.
3 Replies
Anonymous you need to unpivot the data,
transform data -> select id and category column -> right click -> unpivot other data
it will add two columns, attribute and value, rename as you see fit, close, and apply.
now you can use attributes on rows, categories on columns, and value on values and that will do it.
✨ Follow us on LinkedIn and to our YouTube channel
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to 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.
Anonymous just to be more clear, use stacked column chart
x-axis -> attribute column
y-axis -> value column
legend -> category column
✨ Follow us on LinkedIn and to our YouTube channel
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to 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.