Conditional Formatting Pie Graph

[hgmc]

I have 40 odd pie graphs in a report which I need setup and sync conditional formatting for but I can't get this to work.

The problem is, the data values will change for the pie graphs as I change the employee from my Slicer on Pg1.

i.e. Employee 1 may have answers of A B C to show on the graph, and I set the colours I want for them correctly, but when I change to Employee 2, the same graph might need to show A B D - in this case, the graph wont know what colour to assign to value D or it even forgets what colour to assign to A or B. I've spent so much time on this.

Thing is, I have an old report from an ex employee where they have set this exact thing up to work but looking through their report I cant see how they have done it, I've tried to mimick everything they have done but I cant get it to work.

Any insight much appreciated

[MFelix]

Hi @hgmc ,

In this case you need to force the colours you need for each category, what you need to do is to do the pie chart without having any filter on the answers and then go to the colors and for each of the options A, B, ... select the color you need.

If the color that is presented is the one you need from your theme, even them click on that specific color that way when you start to filter by employee the colours will be assumed.

If you don't select the colours speciffically and let the theme to be automatic then the color will change.

[hgmc]

Thanks, that did work but found I had to repeat the setup for every individual pie graph which seems to be a Power Bi limitation? Even if I copy and paste the first pie graph that was setup correctly, it forgets the colour legends I set as soon as I set the Values to the next survey question/data column.