My requirement is adding positive and negative values in bar chart. is there any way to show bar chart in both direction (postive and negative)?
Thanks & Regards,
if it's so; please refer to this:
if u have one positive measure and one negative measure, you just add them as 2 measures in ur bar chart without changing a thing and u'll have ur bar automatically in both directions
Thanks for your reply . I gone through your following article but that is not my requirement. For me I need one dimension with single expression and that expression has both positive and negative no. In my bar chart I want to show both positive and negative bars.
then just create a bar chart, put ur dimension and ur measure and it will automatically happens:
dim : LeadTime
measure: sum(Sales) : it contians both negative and postive values
Create the flag in back-end by,
If(your_measure>0,1,0) as Num_flag
After loading, create the bar chart having two dimension(Your Dimension, Num_flag) and the measure(Your_measure).