P/S: I also would to show the paercentage of both actual and taget on the chart.

Thanks POOJA so much,
Could you attach your workbook that designed as image? i tried to do as you say but still wrong, i am new in tableau

Regards,
Michael.

2 measures are percentage vs MA KPI

Hi POOJA,

I had showed the percentages of Actual and KPI but still not know how to change the color for each like you ! The actual (named percentage)=NS/MA=37,13% and KPI = avg(MA recap KPI)=37,48%

Pooja Gandhi Thanks you so much, i have done, its worked well

Pooja Gandhi I wish you help me to create a donut chart with conditions:

I need to color the donut chart for 3 parts with Red, Orange, Green depend on the criteria:

actual < target - 5%(1) target - 5% < actual < target(2) actual > = target(3)

red color                            |     orange color                            | green color

After that, I need show the location of acctual on the donut chart, for example we have 3 parts of donut chart as:

(1): 35%   --> this part colored red

(2): 55%   --> this part colored orange

(3): 10%   --> this part color green

Actual = 37% ---> actual located at part 2 of donut chart( orange area) and show up a text: Actual = 37% and another text : target =xx%

I try many times to do but it was impossible, i am sorry to ask you again but i believe that only you can help me to resolve this issue soon.

Best regards,
Michael