Range and target visual

[topazz11]

What is the most effective visual to illustrate both the range and the target values?

Something like below.

Thank you,

[v-veshwara-msft]

Hi @topazz11 ,

Thanks for raising this in Microsoft Fabric Community.

As mentioned by @danextian , your scenario has already been detailed in the other thread where the solution is provided and marked as answered:
How do I make this visual

If you need further help with this, please reach out.

Also thanks to @adudani , @Shahid12523 and @Nabha-Ahmed for your valuable suggestions.

[danextian · Accepted solution]

I believe you've raised this question is another pot which I  have already answered. 

https://community.fabric.microsoft.com/t5/Desktop/How-do-I-make-this-visual/m-p/4817505

[Shahid12523]

Use a Bullet Chart (OKViz custom visual) for quickest solution.

Or → native Column Chart with Error Bars (create upper/lower bound measures).

👉 Bullet = easiest, Deneb = most flexible.

[adudani]

hi @topazz11 
try using the "line and stacked column chart" / "line and clustered column chart" visual:

references:
1. Targets vs Actuals Chart in Power BI - YouTube
2. Change the way you Report Actuals Vs Budget!
3. Actual vs Target Trick in Power BI 
hope this helps