Conditional Formatting Colour on Pie or Donut

[CMSINFO]

Hi,

I need to have a pie or donut with certain colours depending on the value, as far as I understand this is a conditional formatting but I only find conditional formatting option in the values of Table and Matrix.  Can someone clarify please?

Thanks!

[MFelix · Accepted solution]

Hi @CMSINFO ,

Conditional formatting is not available for all visual, in donuts charts this is not possible.

On the other visuals where tihs is available you have to go to the options data colours and then select advanced controls, and you get the same window as in the matrix and table visuals.

Visuals with conditional formatting:

• All bar and columns charts
• Scatter Chart
• Treemap
• Funnel
• Table
• Matrix

Regards,

MFelix

Regards,

MFelix

[CMSINFO]

Many thanks @MFelix it clarified! I have an addtional question please.

The data that will determine the colour of the say column chart with the conditional formatting will come from different lines of a linked table....depending on the line of the table selected the column chart will change the colours accordingly but the conditions of colours for each line is different...this means I will need to set different parameters for each line selected to avoid creating one column chart with the conditional formatting for each line of the table....so, in a nut shell, the question is, how can I set different conditional formatting parameters in the same chart, depending on which line the linked table is selected?

[MFelix]

Hi @CMSINFO ,

Check the documentation on conditional formatting especcialy the last part Color formatting by field value.

If you need any addtional help please share some data and expected result.

Regards,

MFelix