Dynamically switch columns on matrix based on the slicer value selection

[Anonymous]

Hi All,

I have a requirement to dynamicaly change columns on my matrix visual based on the value selected in column slicer. I have tried different suggestions in DAX expressions using SELECTEDVALUE() function, but it doesn't give the output as expected. Please help with your inputs or alternative suggestions. Below is the sample data and requirement details.

Sample data:

Scenario :

1. I have a slicer named Group. Requirement is that if I select any "Group" column value in slicer, then the matrix must display values grouped by its respective region. 
2. If I select any "Region" in Group slicer like APJ/EMEA, then the matrix must display values grouped by its respective country.

Below are expected outputs for both above scenarios. 

Expected Output 1:

Expected Output 2:

Thanks!

[Idrissshatila]

Hello @Anonymous ,

check if field parameters will work for your case https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-field-parameters

If I answered your question, please mark my post as solution so it would appeare to others, Appreciate your Kudos 👍

Follow me on Linkedin

[Anonymous]

Hi @Idrissshatila,

Thanks for the suggestion. But field parameters won't work for my requirement. If possible, do suggest if there is any solution with my current slicer structure as shown in the image.