Conditional Formatting on 100% Stacked bar chart

[Anonymous]

I have given a requirement where a color pallet in the following order needs to be applied to the answers. The visual that report is using is 100% stacked bar chart.

order. answer 1 color = #4f9237, answer 2 color = #00AAC3, 3= F6D03A, 4= EB9D00, 5=DD5143, 6=0074BC, 7=9A498B, 8=858F9B.

I am seeing difference in the colors alignment in QA environment after deploying the report.

I have tried to apply conditional formatting but it is not allowing me on legends. I have also tried to create calculated columns but no use. 

Answer Rank =

VAR Currentquestion= Survey[QuestionId]

RETURN

RANKX(

    FILTER(Survey,Survey[QuestionId]=Currentquestion),

    Survey[AnswerText], ,ASC)

2. AnswerColor =

SWITCH(

    Survey[Answer Rank],

    1, "#4f9237",

    2, "#00AAC3",

    3, "#F6D03A",

    4, "#EB9D00",

    5, "#DD5143",

    6, "#0074BC",

    7, "#9A498B",

    "#858F9B"

)

Is there a way to apply conditional formatting without change in visual? Or are there any similar visuals that has same behaviour as bar charts which supports conditional formatting??

[Anonymous]

Hi, @Anonymous 

I am glad to help you.

Conditional formatting does not work with visuals having legend.

Solved: 100% Stacked Bar Chart Conditional Formatting - Microsoft Fabric Community

I would suggest you submit your ideal at this page . If this feature was mentioned by many users, product team will consider to add this feature to next release. 

But you can also set the color manually:

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Fen Ling,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.