Forum Discussion

AlexITRelation's avatar
AlexITRelation
Frequent Visitor
6 years ago

Summing total columns

Hi all,  I've a problem regardring PowerBI, which I've tried to illustrate in excel. I've a matrix with Department in rows and Priority in columns and Low, Medium, High and SUM in values. My p...
grand total
Total Sum
Pragati11's avatar
Pragati11
Icon for Super User rankSuper User
6 years ago

Hi AlexITRelation ,

 

Go to FORMAT options of your matrix visual --> Select "SubTotals" --> Navigate down to "Per Column Level" and switch off totals for "Priority" column. By default you will have "Per Column Level" ON for your "Department" and "Priority" columns.

This should resolve the issue.

 

Thanks.