Forum Discussion
Grouping data in a stacked column chart
Hi,
I am working on making a stacked column chart in power BI to visualize our inventory. We have products with different SKUs but the same names and I want to group the same names under the same color column in the chart.
Normally I would approach this by creating a conditional column and using 'if' statements to categorizes the different SKUs under a common name, however, the data is coming from a Power BI dataset and I don't know how to approach this.
Any help would be appreciated!
Thank you
Anonymous If you are using the Power BI dataset, I would recommend adding this grouping column in that dataset, you cannot add columns when using power bi dataset.
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.⚡
1 Reply
- parry2k
Super User
Anonymous If you are using the Power BI dataset, I would recommend adding this grouping column in that dataset, you cannot add columns when using power bi dataset.
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.⚡