In order to create a 2-color visual using bar charts, I had to create a Calculated field (Goal) that represented 100% of the goal. I then used another calculated field ( % to Goal) to represent how close we are to the goal established, which represents the last quarter of a rolling 4-quarters Sales/Sales Goal desired. The 2-color works for the bar chart, but I can't use the standard process in creating a pie chart because the the 2-colors are a result of 2 measures. Appreciate any feedback. Thanks
Here is the detailed steps for the required pie chart.
Step1: create a new calculated field _Goal for pie
1-[_Percent to Goal]
Step2: Change the marks type to pie and use two measures that you have [percentage to Goal] and [_Goal for pie],
Keeps measure names in colors and measure values in angle.
Attached the file for reference.
Hope this helps!
