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,
I have a dataset that contains rows with Products (each with a unique identifier) which in one column contains all the countries where this product is available - this field is comma deliminated (e.g. "USA, UK, Netherlands" or "UK, Australia, New Zealand"). How do I shape this data so that I can show it in a shape map?
I do have the shape map set up, the countries map to names of the map but currently I only see those datasets that have only one country in the country field and the others don't map to the map. What I would like to have is that when I click on one of the datasets it highlights all the countries and if I click on a country it shows all corresponding rows.
I tried to split the country field into multiple columns but I can only use one column in the shape map visual. (also some products have >30 countries so this a bit messy)
I would appreciate some help with this (I hope i'm in the right place). thanks.
I tried to split the country field into multiple columns but I can only use one column in the shape map visual. (also some products have >30 countries so this a bit messy)
Did you try to unpivot the multiple columns into one once you split them?
Hi,
no I haven't but I will try. However, will that not multiply all the rows? I have another visual that counts another column, which will then show me too many(?), although I can probably get around that by counting (distinct).
I'll try that
any other suggestions? unfortunately that did not work, it still only shows one country per data set
*bump*
unpivoting the data makes them all to be in one column but therefore of course adds a lot of rows. Is there an option to create a linked table?
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
101 | |
86 | |
64 |