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.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

lbendlin , This might work, but I will loose the ability to drill down and up on the Account level.

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.