This ONE IDEA opens ENDLESS POSSIBILITIES | Combining Reference Lines and Parameters in Power BI

[@benjaminruiza]

I loved that you first showed why the conditional formatting didn't change and then how to fix it, this is a really good way to teach :)

[@HowtoPowerBI]

thx for watching Benjamín! Happy to hear you like my teaching style 🙂

[@shermansee]

Your videos are always about combining simple DAX and smart ideas to do amazing things! Love it and keep that going!

[@Chris-wb1pz]

I can’t stop favoriting your videos for quick reference!! Keep it up Bas!!

[@HowtoPowerBI]

so nice to hear Chris 😊 thx

[@estherschachter5942]

Your videos are amazing! I've implemented a number of your tips and tricks into my reports. With much appreciation.

[@brando2818]

This is the first video of yours that I stumbled upon and I just want you to know that you're an excellent teacher! Instant sub

[@jokerMCify]

The value of your content that you are providing to people is priceless! Thank you for all of your work! :)

[@BernieTheBoxer]

Just came off an exercise learning constant lines and then this pops up! Bas - awesome this just makes the whole facility really pop!

[@JustRandomExplorer]

Thank you so much of this X axis formatting technique. Coming from Tableau world this type of things was so much easier done in Tableau. Still learning Power BI and your channel is a great resource!

[@HowtoPowerBI]

I also work a lot with Tableau and you are absolutely right that this is much better handled in Tableau!

[@RichardOliver]

The video title is accurate, Bas. So many things we can do with this!

[@huyhoangnguyen7465]

I come from Viet Nam. Thank for your video. It help me so much

[@HowtoPowerBI]

so nice to hear Huy Hoàng! thx for watching!!! 😀

[@sukoi2113]

You are my favourite Power BI magician

[@HowtoPowerBI]

always wanted to be a magician 😊😉 thx Rajneesh!

[@kartik-wi2jv]

Simply Super.. Thanks for sharing...

[@joaorataoo]

Another excellent video. Thanks Bas

[@HowtoPowerBI]

Thanks again!

[@AmritaOSullivan]

love it!!! these videos are so useful - tips and tricks that can be implemented ASAP!!

[@gambu4810]

Bra you are just brilliant!!!

[@HowtoPowerBI]

haha too much credit!! thanks so much Gambu 😊

[@ivanrybalchenko7225]

Thank you Bas! Your videos are very helpful!

[@HowtoPowerBI]

Glad to hear that! thx for watching Ivan! 😀

[@MaurizioFaini]

Great idea!! Thank so much, I love it.

[@JOSERAULESQUIVELUGARTE]

This is great! Thank you.

[@paulgallagher2987]

This is brilliant Thank You! I've just used it in my latest report. I've also managed to remove a step by having the returned values in your IF measure at 4:23 as "grey" & "blue" and then at 4:37 just select format by 'field value'. Hope this helps someone. :)

[@tubeitz]

Excellent training methodology, thank you

[@HowtoPowerBI]

thx Varun! 🙂

[@bitips]

Amazing Tip !!!!

[@leankassio671]

Valeu!

[@HowtoPowerBI]

hi Lean! thank you sooooo much for supporting the channel :)

[@luiscalabuig8089]

Thank Bas , really impressive videos! Easy to understand. I would like to ask you if it is possible and how to solved the following challenge. I would like to build a waterfall chart between selected month and as many deducted month as input by the parameter. Is that flexibility possible?

[@MrSergb]

Super, very helpful! Thanks!

[@HowtoPowerBI]

great to hear, thank you! 😀

[@MMK_entertainment]

Really loved it

[@ofentsekoolopile4811]

Love it ! Beast Mode !...

[@kingingway3308]

Awesome! Thank you for this great tip

[@HowtoPowerBI]

thx for watching!!!😀

[@PedroCabraldaCamara]

so good Bas!

[@HowtoPowerBI]

thank you Pedro 😊

[@PedroCabraldaCamara]

No! Thank you!

[@adilmajeed8439]

How about color only the portion of the bar which is greater than the constant line or the average line? Any pointers ...

[@HangkinTsang]

Is there any way to avoid hard coding for the constant line?

[@DanielTavares29]

Mind Blowing Video

[@HowtoPowerBI]

😀 😊 thank you Daniel!

[@TrustinData]

Hi , fx option in analytics feature isnot available .please let me know next steps

[@kiranmane8514]

Could you do conditional formatting for constant line color

[@CHQAQC]

Superb video! I have been trying to figure out how to create a vertical line (in the x axis) in a combo chart with column showing the distribution. Any ideas how that can be solved?

[@HowtoPowerBI]

thx!!!! 😀the constant lines you can only add to continuous axes (values or continuous dates). Which I guess is where you got stuck. For categorical fields I don't think there is a way yet unless you overlap visuals

[@CHQAQC]

@@HowtoPowerBI thanks for the response that was pretty much the same coclution I ended up with.

[@sarajvo2010]

Wow, great!

[@stuartmccloud307]

Nice one!

[@HowtoPowerBI]

thanks Stuart!😀

[@balaji_906]

Super great video

[@HowtoPowerBI]

thank you Balaji!!! 😀

[@user-bk8db7ud6k]

Brilliant!

[@krisskrissy]

How can we do this but for 100% stacked column charts?

[@MMK_entertainment]

Can we add the legend for reference line