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 .
Solved! Go to Solution.
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.
@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 + Mango
Mango, Apple + Mango
If need add
Not use this tin visual with filter Apple, Apple + Mango
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 ?
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.