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.

mahoneypat's avatar
mahoneypat
Icon for Microsoft Employee rankMicrosoft Employee
6 years ago

In your example, the desired matrix doesn't show account level for the Total row, so how will you drill down/up?  I think the best way would be to Filter Total from the matrix (visual level filter) and add a card right below or above the matrix that shows a measure for just Total.

 

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat

Anonymous's avatar
Anonymous
Not applicable
6 years ago

mahoneypat , there will be no value drill up and down for Total, but there will be for other Groups value.

 

I would like to have all the Groups in the matrix.

 

Thanks for the suggestion.