Reply
Frequent Visitor
Posts: 2
Registered: ‎11-30-2018

Remove subtotal from only one column in a Matrix in Power BI

Good afternoon to all (here in Brazil is a beautiful Friday afternoon).

 

I would like to know if it is possible to disable the subtotal of only one column in Power BI in an matrix?

 

In this matrix I have some numerical columns where the subtotal does its paper well, and I have a column of text (justification of values that are negative).

 

In this justification column, I wish I did not have the subtotal (because as it is text, it brings either the First record or the Last one).

Member
Posts: 161
Registered: ‎06-05-2017

Re: Remove subtotal from only one column in a Matrix in Power BI

@leofdasilva29  No it is not possible in power bi Post idea here

Highlighted
Established Member
Posts: 255
Registered: ‎03-31-2016

Re: Remove subtotal from only one column in a Matrix in Power BI

If the values being subtotaled could be made into a measure you could use HASONEVALUE to only calculate the measure when there is one value and you could use the IF statement to set the measure to BLANK() so the subtotals will always be blank.

 

Not sure it's what are asking, maybe a screenshot of your data might help.