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
2 measures are percentage vs MA KPI
I have a newer version of Tableau which you will not be able to open because it seems like you have a version earlier than 9.2. Initially when you place measure names on color and measure values on angle, all measure appear in the view. All you need to do is click on the measure in the measure values section in the bottom left side and remove measure you don't need. I don't understand how you are comparing percentage and MA KPI because they seem to be different scales, percentage is very small slice on the pie. Hope this helps!
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%
Donut-Chart.twbx 49.6 KB
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.