% in Stacked charts

[D19PAL]

Hi Guys,

I have two measures as a stacked chart

measure 1 is blue colour (example) and shows as 75 = sum(sales)

measure 2 is red colour (example) and shows as 25 = sum(targets)

so together they show as 75 + 25 = 100

75 blue, 25 red.

How do I show it in %

75% blue, 25% red

Thanks

[joseph_morales · Accepted solution]

Hi @D19PAL 

You must change the definition of your measures by:

measure 1= sum(sales)/(sum(sales)+sum(targets))

measure 2 = sum(targets)/(sum(sales)+sum(targets))

[D19PAL]

• Thank you

Can you help me with my other question about 2 measures in stacked bar summing them up.