Hierarchy in a column

[Anonymous]

Hi everyone, 

I didn't find if it's possible to create a kind of hierarchy inside a column. 

I mean for example, in a column of products that you sale, there are all products of Coca-cola (Coca-cola light, coca-cola cherry etc)
In this kind of column, I would like to gather in one value "Coca-Cola" and after if I use this column in a graph or a matrix, I could "ungroup" to see more in details the sales of each product of Coca-cola. 

For me, this thing is like a hierarchy on powerbi but only for values inside column. 

My question is probably stupid, but thank you in advance for your answer ! 

[davehus · Accepted solution]

Hi @, You can create a custom group by right clicking on the column you are referring to and creating a group. Would this help?

[Shishir22 · Accepted solution]

Hello @Anonymous ,

You can create groups and rename it accordingly.

Right click on the feild and click on New Group.

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-grouping-and-binning

Please mark it as answer if it resolves your issue. Kudos are also appreciated.

[davehus · Accepted solution]

Hi @, You can create a custom group by right clicking on the column you are referring to and creating a group. Would this help?