Vertical Bullet Chart with variance colored

Hi Husain ,

Altough I understand the answer from the other users about using custom visualizations I believe this is not necessary using the Line and Stacked Column chart you can replicate this the steps are:

• Create the following measures:

Below target = if([Below Target] < sum('Table'[Target]), SUM('Table'[Target]) - [Below Target], BLANK())

To Target = MIN(SUM('Table'[Actuals]),SUM('Table'[Target]))

Above Target = if(SUM('Table'[Actuals]) > sum('Table'[Target]), SUM('Table'[Actuals]) - SUM('Table'[Target]) , BLANK())

Target = SUM('Table'[Target])

• Make you visualization in the following way:
  • Shared Axis:
    • Name
  • Column Values (order is very important since the first one is on the bottom of the bar):
    • To Target
    • Below Target
    • Above Target
  • Line Values
    • Target Value
  • Data Labels
    • Customize series: On
    • Show: On only for Below Target and Above Target
  • Shapes
    • Stroke Width: 0
    • Show Marker: On
    • Marker Shape: -
    • Marker Size: 20

Result below:

Now comes the additional stuff.

Title of the chart is dynamic adding this measure:

Title = COUNTROWS(FILTER(SUMMARIZE('Table', 'Table'[Name],"@BelowTarget", [Below target]),[@BelowTarget]>0))  & " Salesman fell short of their Targets this Month"

Has you can see the bottom values that I assume are the targets aren't present this is the only workaround that for me is a bad workaround but gives the final result.

Duplicate the chart and remove all the measures from the values, Place the target on the columns and create the following measure for colouring:

Colour = "#00000000"

On the data laber make it on the bottom of the bar and the colour of the bar make it with the measure above.

Turn off all the of the title, x-axis and so on then place this visualiation on top of the other one final result below and in attach file.

Nothing against custom visualizations but believe that the use of standard gives less maintenance in future updates.

But will give kudos to the other users because their solutions are also practical.