Forum Discussion

SAGUILAR's avatar
SAGUILAR
Frequent Visitor
2 years ago
Solved

Percentage as a row

Hello,   I have the following matrix in Power BI that is showing the 2 rows for every group, qty and %, the goal is to show the total % row (red box) at the botton of the matrix as a total and not ...
  • Ritaf1983's avatar
    Ritaf1983
    2 years ago

    Hi SAGUILAR 
    If I understood you correctly the goal is to switch off subtotals and use just a grand total, you can achieve it by editing a level of subtotal :

    and switch off the subtotal of the lowest hierarchy level

    Result:

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



Ritaf1983's avatar
Ritaf1983
Icon for Super User rankSuper User
2 years ago

Hi SAGUILAR 
If I understood you correctly the goal is to switch off subtotals and use just a grand total, you can achieve it by editing a level of subtotal :

and switch off the subtotal of the lowest hierarchy level

Result:

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