Forum Discussion
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:
I am wondering if there is a way to create a single slicer to for slicing all three columns at once, preferably structured like this:
| UK | |
| Yes | |
| No | |
| Applying | |
| BeingConstructedFor | |
| Expired | |
| Candidate | |
| Sweden | |
| Yes | |
| No | |
| Applying | |
| BeingConstructedFor | |
| Expired | |
| Candidate | |
| Ireland | |
| Yes | |
| No | |
| Applying | |
| BeingConstructedFor | |
| Expired | |
| Candidate |
with each country having their own dropdown list in an hierarchical slicer?
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
4 Replies
- amitchandak
Super User
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-delimiterThe 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?
Facing same... but its fine on my end 🙂
It's looking good and doesn't need to be added in additional rows.
