Barchart target line position need to be fixed middle

[Anonymous]

Hi All,

I am using barchart to show actual and reference value for sales .

Actual is current year sales : ex  Actual 10 

reference is last year sales ex :  8 .

Below report gray item designed as Actual and marker line as reference line . I am using many KPI like this below .

So business wants target line always in same position .  but the same target value will always be dynamic value not same value to put manuallly .

Required format :

Please anyone suggest how to do it ?

[Icey]

Hi @Anonymous ,

Based on my test, there is no direct solution. 

I find one workaround, please check if this could meet your requirements:

1. Create a Bullet Chart by OKViz visual.

2. Create measures for acutal and reference. And then put them into corresponding field.

3. Put your actual and reference columns into tooltips.

4. Don't show the axis.

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi @Icey  Thanks , But in your visual your using same bullet chart for 2 bar line . In my scenario my KPI is different .

Ex : I am using different bullet chart for each KPI . 

Sales net euro 

Sales development percentage . 

So each differnt visula needs to kept in particular position on the target point . Maybe middile of the position . so that actual value will varry based on target .

[Anonymous]

Hi All,

Could anyone expereinced this same issue or could anyone share the different logic to hanlde this ? i am trying hard but no luck 

[amitchandak]

@Anonymous , you can do with bar line visual with like a marker and making line color the same as the background.

very similar to what has been done here.

https://www.youtube.com/watch?v=TV6YRmLYd9s

Or use bullet visual

[Anonymous]

@amitchandak  thanks for sharing feedback . first option is not possible for my requirement .

i need to show target and actual always in the format attached above from bullet chart . 

but the issue is the target value is always changing . But i want to place the targe value in same position and actual value ( Mentioned in gray color need to decrase or increase based on ref ( target value )

Any tips 

[Anonymous]

Anyone update please