I can't color my pie chart based on the conditional format.

Matthias Weidinger shared this problem 5 months ago
Resolved

Based on the doc, there must be the option to enable the existing conditional format in the chart series.


I don't have that option, only the "Aggregation Label", but not what is needed to do that.


What I'm doing wrong here?

Comments (4)

photo
1

Hi Matthias,

Thanks for reaching out. What doc are you referring to here?

I believe what you may be looking for would be covered in the following Idea item: Advanced Conditional Formatting on a Chart.

Can you please read through this Idea and let me know if this appears to be what you're looking for? If so, feel free to vote on this Idea, which could aid in this being considered for future implementation. Either way, please let me know.

Regards,

Mike

photo
1

Hi Mike,


that's actually not what I need and far beyond what I'm trying to do.

As you can see in my screenshots my use case is very simple:


I've a working conditional format on my table and I want to use the same in my pie chart.

Here's the doc for that: https://wiki.yellowfinbi.com/display/USER74/Chart+Formatting

There you find the chart series with the section "style" where you can select the color.


This is completely missing in my case and would fix my problem.

photo
photo
1

Hi Matthias,

Thanks for your response. Not all Series options are available for each chart type. As you can see, if I set up Conditional Formatting at the chart level and do an Auto-Chart, which in this case is a Horizontal Bar Chart, I have the option:

/wH65BODTe8zvgAAAABJRU5ErkJggg==

/g+BCjnrYSgvRgAAAABJRU5ErkJggg==

However, this makes sense, because in the Pie Chart you follow the color of the Dimension, which is not the Series data. In your case this is the 'Color' Dimension, while your Series is the 'Servers' Metric.

Using my example above, what I need to do is apply conditional formatting on my Dimension data ('Athlete Region'), but in order to make the formatting follow results from another column, in this case the 'Sum Invoiced Amount' values, I have to use the Advanced Conditional Formatting option, setting it up like so:

/c1Aer12VpzIAAAAASUVORK5CYII=

/37jEgb6fSZgAAAAAElFTkSuQmCC

This is where the issue regarding the referenced Advanced Conditional Formatting on a Chart Idea comes in, since as you can see, there's no option to choose Advanced Conditional Formatting:

/W1xchMvlOrePDBER0S8dAxgiIroxqsoAhoiIiIiIiIiISFUZwBAR0Q1SVQYwREREREREREREqsoAhoiIbpCqMoAhIiIiIiIiIiJSVQYwRER0g1SVAQwREREREREREZGqMoAhIqIbpKoMYIiIiIiIiIiIiFSVAQwREd0gVWUAQ0REREREREREpKoMYIiI6AapKgMYIiIiIiIiIiIiVWUAQ0REN0hVGcAQERERERERERGpKgMYIiK6QarKAIaIiIiIiIiIiEhVGcAQEdENUlUGMERERERERERERKrKAIaIiG6QqjKAISIiIiIiIiIiUlUGMEREdINUlQEMERERERERERGRqp4fwPwfDXYoQkLt910AAAAASUVORK5CYII=

As a workaround, you can use Basic Conditional Formatting, manually making them match values from another column, like so:

/wcE0fmFzjnCPAAAAABJRU5ErkJggg==

/uNOAAAAAElFTkSuQmCC

/NG9XU+unIeQAAAAASUVORK5CYII=

As you can see, I now have the option:

/w+bYQf0Z5NY1wAAAABJRU5ErkJggg==