Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Conditional Formatting on 100% Stacked bar chart

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??
Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    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.