Hi Anonymous ,

yes, it's doable. I propose the following solution:

1) Create a new table by going to Home -> Enter Data

You can then type in or paste the following:

2) Create a relationship between 'City' in the new table and 'City' the initial table. Make sure the cross filter direction is 'Both'.

3) Add a slicer based on the new column Location

That's it!

Let me know if it works for you. Regards,

LC

Interested in Power BI finance templates? Check out my blog at www.finance-bi.com

hi, Anonymous 

For your case, You may try these two ways:

1. Download the custom visual HierarchySlicer from Marketplace:

HierarchySlicer

and set it as below:

2. In edit queries, Select Region, Country, City column., Then Unpivot them

https://www.newtechdojo.com/unpivot-columns-in-power-bi/

Then use this new column as a slicer.

Regards,

Lin