Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Matrix regroupe based on Slicer value

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 ...
Need Help
v-frfei-msft's avatar
v-frfei-msft
Icon for Community Support rankCommunity Support
7 years ago

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's avatar
Anonymous
Not applicable
7 years ago

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=eyJrIjoiMmMzZTYzNWItMGNiNy00YjA0LTlmNjktYzY2MzhkN2RmNjRmIiwidCI6IjA4NDNhY2VjLWZkM2UtNDliZS1iZDU0LTE4YzYwNDhhM2ZkMCIsImMiOjN9

 

And also screenshots attached:

Screenshot 1Screenshot 2

 

Thanks a lot in advance!