Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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
Solved! Go to 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.
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.
Hi Lionel
Thanks, it works.
Best
Rainer
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
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.
@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
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
Hi Amit
Thanks for the message. I will try it and give you a feedback.
Best
Rainer
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
112 | |
89 | |
82 | |
76 | |
64 |
User | Count |
---|---|
142 | |
111 | |
108 | |
99 | |
95 |