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 😀

[@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

[@rus1ickoff]

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

[@rbs6742]

Very creative and intelligent. Tks.

[@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!

[@azarao0]

I am using it on my report. Very helpful.

[@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

[@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.

[@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?

[@KhalilAhmad74036]

Great information, thanks.

[@mindypeck427]

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

[@bharathishamma1159]

Very insightful

[@GoodlyChandeep]

Thanks Bharathi!

[@ricardo8500]

Thank you so much.

[@natashailina5005]

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

[@pepper_lab]

Awesome 😎😎😎👍👍👍 Thank you

[@mogarrett3045]

excellent tutorial

[@GoodlyChandeep]

Glad you liked it Mo!

[@mogarrett3045]

@@GoodlyChandeep absolutely brotha

[@trongpham9999]

awesome guy!

[@sudip.official]

Very much interesting ❤

[@giangluong8185]

Awesome chart interaction. Can you make similar chart in excel

[@GoodlyChandeep]

kzbin.info/www/bejne/ZmTQm5uugZqtfsU

[@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

[@andreasrehmer7872]

Cool Idea. I Like IT.

[@GoodlyChandeep]

Glad you like it Andreas!

[@jamiicodeles]

Nice one

[@pavelandreev6023]

Really nice 🎉

[@GoodlyChandeep]

Thanks Pavel!

[@954giggles]

Thanks! Wish I could send more 😭

[@GoodlyChandeep]

Thanks a lot Yvette.. Appreciate the gesture :)

[@bulbulahmed3098]

Great.

[@laiqmehdi8704]

Awesome 😊

[@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.

[@arghyadutta9091]

Great

[@kebincui]

Cool

[@GoodlyChandeep]

Thanks Kebin!

[@dilipinamdar5523]

Thank you so much.🙏

[@GoodlyChandeep]

Welcome Dilip!