March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
Hi There,
I am facing an issue in Matrix table where i have one column which consist of two groups or two values (e.g Table 1 consist of Food Items which have "Apple" and "Mango") and i want to show total of Apple and Grand total only in matrix table week wise .
Can anyone help how can we achieve this ? @amitchandak @Ashish_Mathur @jihwan_kim
Thanks,
Ashish
Solved! Go to Solution.
Hi,
You may download my PBI file from here.
Hope this helps.
Hi,
You may download my PBI file from here.
Hope this helps.
Hi @Ashish_Mathur ,
Thank you ever so much for your help. Appreicate it !
Can you also help how can i achieve Apple% =(Total of Apple/Grand Total) just below Grand Total.
Please see below desire result :
You are welcome. I do not know how to do that. I think there can only be 1 Grand total row. Let's wait for someone else to contribute.
No Problem, Really appreicate your inputs.
Cheers !
Thank you.
@ash_cool10 , You have to create a table like the one suggested in blog. You can directly use with with you table many to many join
A new Table
Food Item , Fod Item Group
Apple, Apple
Apple , Apple + Mango
Mango, Apple + Mango
If need add
Mango, Mango
Not use this tin visual with filter Apple, Apple + Mango
https://amitchandak.medium.com/power-bi-add-grand-total-row-in-the-bar-visual-44c3d1d463be
Hi @amitchandak ,
Thank you for your prompt response.
I tried to create the same as you suggested however its not going to solve my issue as once i select "Select All /Single Select on any food item but its not going to give me desire result " beacause if i select any one of the values from new table its going to select single field and grand total will show only that item value however i want only Apple selected in field and Grand Total will be of (Apple +Mango) week wise.
Can you please help me on this ?
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
User | Count |
---|---|
93 | |
87 | |
84 | |
76 | |
49 |
User | Count |
---|---|
163 | |
148 | |
103 | |
74 | |
55 |