Hierarchical slicer for multiple columns

[hbirk]

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?

[Anthonyblanco]

It's looking good and doesn't need to be added in additional rows. 

[Anthonyblanco]

Facing same... but its fine on my end 🙂 

[amitchandak · Accepted solution]

@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

[hbirk]

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?