Thank You for posting your query onto the Forum.
As it was suggested in the previous post provided below that un-related slicers will not have any direct effect over the selection made between the two. You’ll be required to include that within the one table so that one slicer have the effect over another. You can go through the previous post for the entire explanation.
Extending to that part, I’ve added the Index column in the Sales Data and have added new table (in this case to provide the solution) which contains the columns of Index, States, Country and Currency. Now, just establish a one-to-many relationship between the tables based on the Index key or column and one slicer will be affected by the another. Simple!!! No complex techniques performed to achieve this.
Here’s the screenshot of the result provided for the reference -
I’m also attaching the working of the PBIX file for the reference. Again I recommend you to please go through the “Data Transformations and Modelling” course.
Thanks and Warm Regards,
Dynamic Slicer Test v2 - Harsh.pbix (88.3 KB)
Country, State and Currency Selection.xlsx (11.4 KB)