Forum Discussion
Solved
Hierarchical slicer for multiple columns
Hi! I have data that is structured something like this: Where the numbers in each cell are linked to each individual but identical explanation tables that look like this: ...
hbirk , Better to unpivot table 1(Then split the column) , Then you can drag country from table 1 and meaning from table 2 in visual
https://radacad.com/pivot-and-unpivot-with-power-bi
https://learn.microsoft.com/en-us/power-query/split-columns-delimiter
amitchandak
Super User
Super Userhbirk , Better to unpivot table 1(Then split the column) , Then you can drag country from table 1 and meaning from table 2 in visual
https://radacad.com/pivot-and-unpivot-with-power-bi
https://learn.microsoft.com/en-us/power-query/split-columns-delimiter
The tables are pulled from a database, and all rows contain additional information as well. When unpivoting it creates a lot of extra rows, Will this affect performance or is there a way around this?