How can i hide grouped data while keeping the data

[newtobi23512]

Hello, I am fairly new to Power BI and I calculated the percentage of column totals. I would just like to see the Black portion but keep the calculation as shown (1.92%, 2.44%, 2.53%). Getting rid of the green. Is there a way to do this?

[MFelix]

Hi @newtobi23512,

Don't know how you calculated the measure bit you need to have a neasure that looks somethong lile this

Dealer % =
DIVIDE (
CALCULATE ( SUM ( TABLE[column] ); Table[Dealer segment group] = "Wholesaler" );
CALCULATE ( SUM ( TABLE[column] ); ALL ( Table[Dealer segment group] ) )
)

Change the table names and columns names by the ones in your table.

Not at computer so DAX syntax may have to be adjusted a little.

Regards
MFelix