Skip to Content
avatar image
Former Member

Conditional Formatting Chart Bars based on another field

I have a chart that displays totals by Citizenship. The citizenships are broken up into two groups. I want to show a color difference for Bars from each group. Each country is only part of one group. Since I can't find a way to conditionally format the bars using another field that indicates which group they are in, I have to create two totals, one for each group. If I put the data in a regular column chart, there are two bars for each country, but only one shows. It properly color coordinates, but it looks sloppy as the bars are only half as wide (because it thinks there is going to be another bar for the other total). So I tried using a Stacked Column format and it works perfect.... except for the labels are only in the bar. I understand that traditionally Stacked columns have more than one section so having the label be in the middle makes sense. But when there is only one data set, I want to be able to show the data value on top. Some of the totals are very small and so it will only show the total if it is on top. If anybody knows how to accomplish this I would appreciate the help. Thanks.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Feb 15 at 11:42 AM

    check attached blog or you can try with column chart with dual axis.

    https://blogs.sap.com/2013/09/19/alerters-in-webi-40-charts/

    Add comment
    10|10000 characters needed characters exceeded