How to create a chart showing positive and negative values as in the attachment

[Grantx]

Hi,

How is the following type of chart acheived? Also, can it be made to stand on end ie. rotated 90 degrees to an upright position?

MAny thanks.

[Grantx]

Thank you. Very much sppreciate your response.

[HassanAshas · Accepted solution]

Click on the Chart, go to Format your Visual in the Visualizations pane. Search for "Columns" attribute and then click on "fx" to apply conditional formatting in your Chart.

There on, use the following rules, 

You need to select "Rules" as your Format Style, and in the the field column, select the "Measure" or the Aggregate Column value (in my case, it is Sum of Revenue) that you are using on your Y-Axis. 

Now, create the rules as you would like to see the colors (I copied the colors from your chart and made the rule accordingly. You may copy the rules as I applied above to get the desired result) 

As for rotating it 90 degrees, do you mean to say changing the Chart's direction to horizontal bars? You can easily do it by changing the chart type to Stacked Bar Chart. Click on this chart as depicted in the image below,

You will get a result similar to this, 

[Vinod_P]

Hi ,

Is there a way to compare with dynamic value ? 

For example I want to compare the average sales vs total average sales