Grouping values and toggling visibility of details

[Anonymous]

Hi community

I've the following challenge. I've a table which looks like this:

Customer	Product	#Products	#Shop visits	#Internet visits	Shop sales	Internet sales
1	2	2	2	98	300	200

In my report I need a matrix which looks like this

			#Visits			Sales
Customer	Product	#Products	Total	#Shop visits	#Internet visits	Total	Shop sales	Internet sales
1	2	2	100	2	98	500	300	200

I know it's easy to get the 2 total columns but what I need is: I'd like to toggle the visibility of the details like I can do it on row groups. I've tried it with out of the box grouping but teh result wasn't very satisfying.

Can you help me?

Thanks

[Anonymous]

Hello

I've created a hierarchy which I named "Column Group" (contains "Visits" and "Sales") and "Columns" (contains "Shop visits", "Internet visist", "Shop sales" and "internet sales"). If you put this hierarchy into columns of the matrix and you choose drilling columns you can switch show only the groups or groups and details. Unfortunatly it's not possible to have a + symbol like in a row hierarchy.

Hope that helps.

[v-lionel-msft · Accepted solution]

Hi @Anonymous ,

Maybe you can do like this.

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi Lionel

Thanks, it works.

Best 

Rainer

[Anonymous]

Hi Lionel Chen

Thanks for your message. Do you mean a measure group? I've tried this but I didn't managed to toggle the visibilty of the detail of this group. Did you?

Best

Rainer

[v-lionel-msft]

Hi @Anonymous ,

This is similar to the date hierarchy.

You can manually drag and drop the fields in the ‘Field’ pane on the right.

--Hold down the left mouse button and manually drag the field.

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , You have to do some column grouping for that.

column header grouping
https://www.daxpatterns.com/dynamic-segmentation/
https://community.powerbi.com/t5/Desktop/Matrix-Display-Values-above-Columns/td-p/256905
https://community.powerbi.com/t5/Desktop/grouping-measure-results/td-p/456795

[Anonymous]

Hello Amit Chandak, 

Thanks again for your answer. I solved it in an other way but your answer is very helpfull for me for a task I got yesterday.

Best regards

Rainer

[Anonymous]

Hi Amit

Thanks for the message. I will try it and give you a feedback.

Best 

Rainer