Matrix regroupe based on Slicer value

[Anonymous]

Dear Friends,

I am given a task to create matrix visual and dynamically group it based on value selected on Slicer (report have to be created). I only could found out how to filter data based on Slicer value.

I know that it is possible, I saw report published on web, matrix on it is regrouped evry time different value is selected from drop down list. I am not sure if used elements are slicer and matrix. I only see that table summarizes data and is regrouped based on item selected in drop down, and is filtered based on vlue selected in other drop downs.

Can you please help me to understand how can it be done?

Thank you in advance!

[v-frfei-msft]

Hi @Anonymous ,

Could you please share your sample data and excepted result to me if you don't have any confidential Information.Please upload your files to One Drive and share the link here.

[Anonymous]

Hi, @v-frfei-msft 

Please see example files attached,

It contains matrix with Date and City fields and have to be grouped based on one or two of slicers.

For example I may want to group files by Region, or by Years etc. I am not sure if provided example is good for implementing such kind of grouping, but i hope it will help to understand what is required.

Here is a link to shared report:

https://app.powerbi.com/view?r=eyJrIjoiMmMzZTYzNWItMGNiNy00YjA0LTlmNjktYzY2MzhkN2RmNjRmIiwidCI6IjA4N...

And also screenshots attached:

Screenshot 1Screenshot 2

Thanks a lot in advance!