Conditional Formatting in Graphs/Charts

HarunT
HarunT
edited March 19 in Modeling

Hello,

I am working on a project that requires conditional formatting for a graph, such as orange for bottom 10 products and blue for the top 10 selling products. Is it possible in Anaplan or is there any workaround for this? Please see the attached picture for a sample graph I want to create. Thanks

CF in graphs.png
Tagged:

Answers

  • SriNitya
    SriNitya
    edited March 20

    Hi,
    You can create 2 separate graphs to display top and bottom 10 products sold, in chart card you can configure the colors. Similar graph as in your image is not possible.

  • devrathahuja
    devrathahuja

    @HarunT - Hi,
    If you want to show it all in 1 graph, you can create 2 line items & then use different colors in the chart settings.

    Line item 1 (Bottom 10) - Have a formula as If bottom 10 then value else Divide(0/0)
    This would give a NAN for the line item for other cases & not be shown in the chart.

    Same for Line item 2 & then publish both on the chart & set line item 1 color as blue & the other one orange

Categories