A collection of PowerBi Pie charts and their colouring consistency

[rjm]

Hello,

I have a PowerBI report that needs to contain quite a few pie charts, which are reporting on the output of a 'likert' grid from Microsoft Forms, whereby a respondent provides an answer from a consisent set of multiple choice answers across a number of questions (gauge of opinion etc.).

I would like the colour of each segment of the pie charts to consistently represent a given common answer (e.g. agree, disagree, strongly disagree etc.).  Not only does PowerBI not seem to have the intelligence to auto-assign the same colour scheme as it did on the previous pie chart, the Format Painter does not seem to apply to these settings when tried.

Other than manually going through each and every pie chart setting the colour scheme, what approach would you take to this?

Richard 

[amitchandak]

@rjm , For pie visual conditional formatting, is not Supported.

You can vote for the Idea

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/34906837-conditional-formatting-i...

Also, check if custom visual can help

https://appsource.microsoft.com/en-us/marketplace/apps?product=power-bi-visuals

[TomMartens]

 Hey @rjm ,

unfortunately it's not possible to assign a color to categorical values.

This means, you have to adjust each pie chart.

If you do not have to use pie charts, as pie charts are not supporting conditional formatting

For this reason I create a measure that returns either the name of a color or a valid hexcode. Here is an example of for a DAX statement:

fill color product color =
var productcolorname = MAX('DimProduct'[ColorName])
return
SWITCH(
     productcolorname
     , "blue" , "red"
     , "Gold" , "red"
     , "grey"
    )

Then I assign this measure to the default colors of the bar chart:

and choose this rule

and the chart will look like this:

Hopefully, this is what you are looking for.

Regards,

Tom