Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Power BI remove row breakdown for some group values

Hi, I have blelow data, the value of Total = Inventory + Trade + Others. What I want to see in the matrix is  to have only one line for Total, I don't want the breakdown of the Accounts for T...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    6 years ago

    Hi Anonymous 

    Create a calculated column like

    cate = SWITCH(TRUE(),[Group] in {"Inventory", "Trade", "Others"},"total")

    Add matrix like:

    Best Regards
    Maggie
    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
6 years ago

I don't think you mentioned that requirement.  Have you tried using a matrix visual where you put Group and Account in the rows, Amount in the value, and nothing in the columns?  Then expand all groups except the Total group.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

I did not mention that  because I thought that is obvious, if you have any column in the row you would want to drill up and down.

Thanks for your matrix solution, I am aware of that solution, but I thought I would ask if there is another solution.