This is something that would be relatively easy to build using our Component SDK. But you can do something very similar using the combo chart with scatter as the secondary measure which will place a dot on the chart. See my example here. Hope this helps, if you have any follow up questions @mukulranjan, please let me know.
Thanks for the alternate option, this is the exact solution I have at present but it has a gap. In my current requirement I have 6 measures. 3 separate sets of value and target, linked together with colors (same color for 1 pair of value and target). but if you filter the insight with one set the column and dots do not align, dots come on top of each other instead of on top of column, as below
Is there a way I can always keep target dots on top of each column measure?