Show remainder that is less than the max on stacked chart

[Anonymous]

Hi all,

I would like some assistance in making a normal stacked chart look like a 100% stacked chart.

I have a measure that calculated the count of head for different facilities.  I would like another measure that shows the maximum heads minus the count of heads for each facility for aestetic reasons to have the empty spaces as seen below filled with a darker shade of grey. Any alternative approaches are more than welcome.

Thank you

AndreM

[MFelix · Accepted solution]

Hi @Anonymous .

Use the following two measures:

Count_Cat = COUNT('Table'[Cat])

Total_value_Cat = 
MAXX (
    SUMMARIZE ( ALL( 'Table'[Cat] ); 'Table'[Cat]; "@Count_Cat"; [Count_Cat] );
    [@Count_Cat]
) - [Count_Cat]

If you want to have the measure based no the selected categories on a slicer you need to change the ALL to ALLSELECTED.

Check the PBIX file attach with both option.

[Anonymous]

Thank you @MFelix it works perfectly