Highlight Values below Target in Power BI

[@julie_chen]

I am going to need to create exact visual like this today !!! Thank you so much ❤❤❤

[@rohitwaradpande2492]

Every time I am seeing this video, it's getting better and better ... Hats off to you for all the dynamism you bring with your videos .. Be it power BI or Power Query ... Your tricks and way of explaining things are superawesome ...

[@GoodlyChandeep]

Thank you so much Rohit 😀

[@rbs6742]

Very creative and intelligent. Tks.

[@JasonSykes7579]

This is a great technique for reporting on KPIs. If it possible to use two different targets, so that the columns end up with three different colours? Red for under minimum target, Amber over minimum but under ideal target and Green for over ideal target

[@azarao0]

I am using it on my report. Very helpful.

[@rus1ickoff]

Nice. I am gonna use some tricks of this solution for my Pareto chart. Thank you very much!

[@emilmubarakshin49]

Thank you Chandeep. It is an amazing concept which can be applied in so many different cases. I'll be sure put it to good use.

[@patrickbrom2702]

Marvelous usecase! gonna se this in my next role, starting next month.

[@GoodlyChandeep]

Awesome Patrick!

[@antonycatella5901]

Loved the video Chandeep. Given me an idea for a report I am working on

[@roywilson9580]

Thanks for the interesting and informative video. This could be a very useful technique to have in one's arsenal.

[@ershelin]

Very useful. yes, I can use this for tracking tendering cycle time vs set KPI

[@KhalilAhmad74036]

Great information, thanks.

[@ricardo8500]

Thank you so much.

[@dilipinamdar5523]

Thank you so much.🙏

[@GoodlyChandeep]

Welcome Dilip!

[@bharathishamma1159]

Very insightful

[@GoodlyChandeep]

Thanks Bharathi!

[@pepper_lab]

Awesome 😎😎😎👍👍👍
Thank you

[@trongpham9999]

awesome guy!

[@sudip.official]

Very much interesting ❤

[@arghyadutta9091]

Great

[@andreasrehmer7872]

Cool Idea. I Like IT.

[@GoodlyChandeep]

Glad you like it Andreas!

[@lionels839]

Thanks. I will use it in my report if I find how to deal with averages (my transaction is a daily average). Best regards.

[@mogarrett3045]

excellent tutorial

[@GoodlyChandeep]

Glad you liked it Mo!

[@mogarrett3045]

@@GoodlyChandeep absolutely brotha

[@bulbulahmed3098]

Great.

[@laiqmehdi8704]

Awesome 😊

[@jamiicodeles]

Nice one

[@pavelandreev6023]

Really nice 🎉

[@GoodlyChandeep]

Thanks Pavel!

[@kebincui]

Cool

[@GoodlyChandeep]

Thanks Kebin!

[@954giggles]

Thanks! Wish I could send more 😭

[@GoodlyChandeep]

Thanks a lot Yvette.. Appreciate the gesture :)

[@9930danny1]

Hi, I am relatively new to Power BI and would really like to implement this. I am getting stuck on creating the measure/calculation for the conditional formatting though. When I am trying to create my measure it is only allowing me to select other measures! I can't seem to select the 'totalusers' (in my case a website count) in another table. Can anyone help me overcome this?

[@giangluong8185]

Awesome chart interaction. Can you make similar chart in excel

[@GoodlyChandeep]

ruclips.net/video/03mjhxL5zHc/видео.html

[@natashailina5005]

Thanks! But I can't sort months on the chart logicaly

[@mindypeck427]

where can we get a copy of the file you mentioned in the video?

[@gurureddyn1879]

Hi where so we find in reference line option in chart .. i could not find that . Which version it is available

[@antonycatella5901]

Goodly had the On-Object Interaction turned on. If you are not using On-Object Interaction then the Constant line feature is found in the Visualisations pane under Analysis options

[@abdulsaidmkamara7305]

I understood all parts except the last DAX for the conditional chart title is really hard.

[@GoodlyChandeep]

I know!

[@abdulsaidmkamara7305]

@@GoodlyChandeep We do appreciate you sharing your prowess with us though we are learning.