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 as a subtotal on every row.

Is there a way to do it?

 

  • 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



1 Reply

  • 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