Forum Discussion

Ranjith_96's avatar
Ranjith_96
Helper I
2 years ago
Solved

Need only grand total for Matrix Visual

Hi Power BI Community, In the matrix visual below, i dont want the subtotals, i only need the grand total. Is it possible to acheive? Any suggesstions would be really helpful.  
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Ranjith_96 

     

    As the Daniel29195 above said, His method is correct, maybe there are some problems with your operation process.

     

    I created a table based on your screenshot.

     

     

    Then follow the steps marked on my diagram to achieve your needs

     

     

     

     

     

     

     

    Best Regards,

    Jayleny

     

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

     

  • Daniel29195's avatar
    Daniel29195
    2 years ago

    Ranjith_96 

     

    go to row subtotals,

    enable the per row level : 

    choose from the dropdown , category , 

    and turn off total

     

    then choose service, and turn of subtotal .

     

     

    let me know if this helps .

     

    If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution
    It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠

  • Ranjith_96's avatar
    Ranjith_96
    2 years ago

    Thanks Anonymous . Thanks a lot. it worked