Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to Solution.
So like the attached?
Hi, before I say "Yes", can you please show your excpected result to help us understand completely your idea?
Regards,
Happy to help!
I think you will need to unpivot your data.
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
So like the attached?
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,
Happy to help!
legends! Thank you both for your help 🙂
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 😕
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
97 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |