Line item with multiple tag/categories

[Anonymous]

Hi, in need of some help - could be a very simple fix. 

I have a large db with line items with multiple tags (both high level tag and low level sub-tag)

Each line item may have more than one tag/sub-tag and also may have the same high level tag twice but a different low level sub-tag. I essentially want to create a pivot table showing tag > under it sub-tag. Is there a way to do this with PowerBI? thanks in advance!

[ibarrau]

Hi, before I say "Yes", can you please show your excpected result to help us understand completely your idea?

Regards,

[Greg_Deckler]

I think you will need to unpivot your data.

[Anonymous]

It is not pivoted? I want a pivot table or essentially a table displaying:

Tag (X)                             Count

----Sub-Tag (a)                Count

----Sub-Tag (b)                Count 

Tag (Y)                              Count 

W all the tags collated. Etc...

Thanks 

[Greg_Deckler · Accepted solution]

So like the attached?

[ibarrau]

Ok. The data is like "pivot". So you can select your tag columns in edit queries and look for the "unpivot columns" option to make that expected result work.

Hope this helps,

[Anonymous]

legends! Thank  you both for your help 🙂

[Anonymous]

Sorry, the problem I am having is that there are some lines w say 

Tag X, Sub-tag A but also Tag X, Sub-tag B?? Hope that helps 😕