1 Trick for Endless Power BI Charts!

Join my Power BI Design training here: my.datatraining.io/pages/powe...
Learn this 1 trick to create a wide variety of new charts natively in Power BI. In this video I show you how to do it. Enjoy and subscribe to always stay updated on my favorite Power BI tricks :)
Download file here datatraining.io/powerbi-how-to
--------------------------------
📊 TRAININGS 📊
---------------------------------
Power BI Design 4 Weeks Transformation Program my.datatraining.io/pages/powe...
Power BI Essentials datatraining.io/powerbilearni...
Business User Training datatraining.io/powerbi-busin...
For Custom Trainings and Consulting email directly [e-mail]
---------------------------------
⏱️ TIMESTAMPS ⏱️
---------------------------------
00:00 Intro
00:24 Chart 1
10:51 Chart 2
15:37 Chart 3
19:50 End
---------------------------------
😍 JOIN 😍
----------------------------------
Join bit.ly/4b453bi
Subscribe bit.ly/31MnQGO​
Insta / howtopowerbi
LinkedIn / basdohmen
TikTok / how.to.power.bi
X / howtopowerbi
fb / howtopowerbi
Threads www.threads.net/@howtopowerbi
Newsletter datatraining.io/newsletter
---------------------------------
👇 CHECK THIS OUT! 👇
---------------------------------
💻 My gear amzn.to/47F21Yc
📚 Power BI books MUST READ! amzn.to/3tUfFcj
💡 General books I recommend amzn.to/48YNo33
🎶 Music for my videos www.epidemicsound.com/referra...
🚀 For growing on KZbin: www.tubebuddy.com/bas
🏄 Stuff I use daily amzn.to/3HqfMQ2
* Above are affiliate links, which means at no additional cost to you, if you make a purchase using these links we will receive a small commission. It supports us and helps us to continue making more How to Power BI videos!
Thanks for being a part of this channel and all your support! 💪 🙏
#HowToPowerBI​ #PowerBI​ #DataTraining​
#powerbidesktop​ #powerbitraining​ #powerbideveloper​ #DAX

[@user-ze4xc6tu4f]

This youtube channel does not talk about power bi, it's all about magic

[@PowerBIPark]

Awesome Bas! Nice method of setting the bar chart 🔥

[@HowtoPowerBI]

😎👊

[@gergelyfalvay9238]

Love the way how you hacked green vs red when there's no FX button. I did the same for a YOY change bar chart combined with Calculation groups - one group only calculated the negative values and the other calculated the positive ones. So 2 item used in the bar chart visual and now I could set CG1 to red and CG2 to green.

[@HowtoPowerBI]

thank you! a fx button would have been nice though 😅😁

[@mohammedishaq9217]

New hands on Power BI, Your Tips have actually being a great inspiration. You do pure Magic there.

[@HowtoPowerBI]

😎👊

[@mercedesiacuzzi7767]

Amazing! excellent way to show the variances without showing them in a typical table... I am going to apply them shortly. Thanks for all you share!

[@richardandrews1325]

Superb work!!! This will be used on next assignment, much appreciated!!

[@leandrodelrio]

Bas your creativity is insane! Thanks for sharing.

[@nitesh791102]

Awesome Bas, I have been waiting for these from ages.

[@hoaconghoangphi]

This is so insane! Your video tips help me a lot. Many thanks Bas!

[@HowtoPowerBI]

Happy to help! 😊thanks for watching them

[@saraoiman]

Amazing! Really appreciate your pursue to perfection 🌟

[@nimikajadav3004]

Awesome Bas ! By setting up a new chart using error bars, I am becoming a big fan. You have created a very nice visualization

[@fart_restoration]

Thank you for all the great tips and also thank you for wearing that shirt! 😍

[@Daithi354]

Wow, nice timing, I am literally just now trying to add a dumbell chart. This new functionality is awesome, thanks for the very useful vid

[@HowtoPowerBI]

ah perfect, especially for you a timed it like this 😋😉

[@a.b.8444]

Amazing work Bas!! Love your workarounds and little "hacks" for PBI 😊

[@HowtoPowerBI]

Thanks! 😀

[@zhangyue2740]

this video is very perfect！！！ thank you

[@AujieAlamban]

Awesome. I’m slowly learning with your contents as beginner.

[@HowtoPowerBI]

why not fast 😋 .. awesome, happy to be part of your learning journey

[@unnikrishnansanthosh]

another incredible one from the Guru

[@HowtoPowerBI]

😊😊😊 thank you

[@julio18412]

excellent content man! as always

[@HowtoPowerBI]

Appreciate it!

[@spilledgraphics]

hat off = amazing Bas!

[@elielias96]

Amazing, such a creative approach to take advantage of every new features release Do you have similar content also for Tableau?

[@arbazahmad7177]

Excellent 🎉thanks for sharing 👍

[@HowtoPowerBI]

Thank you! Cheers! 😊

[@samueljunioryimga7914]

awesome! thanks for great content . one question: how do show outliers with this trick of yours

[@Simone_R_C]

Awesome Bas, as always! I'm wondering if it's possible to include outliers in the box plot chart maybe as dots instead of using the max/min as 0.95/0.05 percentile! Do you think could be useful or not for the box plot chart?

[@JonnyCowell1975]

Thanks for this great idea - I can't figure out how to get the error bars working from the constant centre line, or any constant line for that matter. Any thoughts on why that might not be working for me?

[@hamidsh4789]

Amazing lesson. Thanks heap.

[@HowtoPowerBI]

Glad you liked it!

[@paulwyatt8523]

What a fantastic chart Bas - now my most favourite chart of all. I'm looking to replace so many column and bars with this. If anyone is interested, I have replaced the circle icons with ▼ for neg and▲ for pos. Whilst there is only actually one triangle ▲ icon available, place the the neg measure into the lower bound (see video point 7:30). Now the chart will compensate either for rows or for columns. Thank you so much for this Bas

[@HowtoPowerBI]

awesome, thx for watching Paul

[@davidjosevarelagarcia7011]

how ever, great video y content , just a question, it can do it , adding the var % , another vertical line side by side?

[@wiiori4618]

I love that you demonstrated this new feature as I didnt know about the error bars. That said, I dont know if this is so practical in a business setting where charts tend to be more dynamic. Seems to be way too much input just for one chart and possibly a hassle to troubleshoot if one of the measures buried in the error bars is faulty. But I'll explore it. Thank you.

[@HowtoPowerBI]

Useful on projects im working, bet for most others here too

[@user-mq2vz5yh6g]

Awesome Bas!

[@mustafaragab4400]

Hey Bas, thanks alot for this amazing tutorial, I was wondering if there a way to add a variance % on the reference line?

[@davidjosevarelagarcia7011]

Excellent contribution and thanks for the resource. I was reviewing the file and when I select the year 2020 and a category the following happens 1) when I select a year and a category, one or more negative lines overlap the bars of the current value and I don't know how to prevent them from overlapping 2) Is there any way to dynamically adjust and overlap neither the lines nor their labels on the bars of the current value? I would greatly appreciate your contribution

[@taitu7538]

nice trick. bravo. thank you for sharing

[@HowtoPowerBI]

😊 thx

[@zahir585]

Brilliant ❤

[@laitig2463]

wow, it's incredible!

[@HowtoPowerBI]

thanks!!!

[@GuyOrlov]

I love your chart 2, bravo 🎉

[@HowtoPowerBI]

thanks!! 😁

[@HachiAdachi]

Thanks, Bas! Had NO idea that Feb 2024 update snuck it in there. 😀 Miguel has been keeping himself busy, I see! 😉

[@HowtoPowerBI]

visual calculations were getting the spot light this month lol ;)

[@anhhuynhtori6510]

What screen recorder software did you use for your video?

[@rajarshisingh2547]

Best video seen today

[@HowtoPowerBI]

hope it wasn't the first one then :p .. thank you!

[@user-wx3dn3il2f]

Amazing

[@nikahafiz1]

what if the variance (Revenue Actuals CY vs PY ) has negative value? how will the error bars be shown or be adjusted/modified to show correctly?

[@venkatapraveenjannu4868]

Awesome 👌

[@HowtoPowerBI]

🙌

[@xalil102]

Très instructif, Par ailleurs, je sais pas comment vous avez reussi a afficher l'étiquettes de label positive left tout a fait a droite. Je selectionne bord extérieur mais ça le positionne sur la ligne, et si je sélectionne bord intérieur, ça s'affiche pas

[@matiasgasperini]

Great job! I'm always amazed by your creativity! I'm not sure how did you managed to set the left label (for the first chart) in place. If anyone has the same problem, I subtracted a small amount from the formula for the left label (such as 5% of the "Revenue Variance Center")

[@EmileDavis]

I had that same problem! Selecting Outside End placed the label on top of the bar. So frustrating. I can't say exactly how I resolved it, as there was a lot of try this, that, and the other...But the end solution uses Inside End as the position. I feel like doing just that didn't do the trick. I toggled the transparency of that bar from 100% to

[@khalidkholaidy]

Awesome ! I will be use this in my reports , but how I can arrange and organize my measures in a folders and sub folders like you ?

[@HowtoPowerBI]

here you go kzbin.info/www/bejne/mXjRiIOrlpKWo9E

[@davidjosevarelagarcia7011]

Hello, I have a problem with the values, due to the great difference in the variation, they overlap the bars. However, try changing the number that is multiplied by 1.75 to 3.25 and so on, they continue to overlap, any ideas? greetings

[@user-sh3md4gg2q]

Awesome! Other than Power bi, I want to learn "Editing" from YOU!!!

[@HowtoPowerBI]

🙏 thanks , maybe for a different channel lol

[@LinhTran-ys1mt]

awesome!

[@HowtoPowerBI]

😎👊

[@agustinpisano8064]

Nice!!

[@HowtoPowerBI]

thanks! 😊

[@TenhoDados]

Wonderfully incredible. I wonder how many hours you spend figuring out these tricks. Congratulations on the work!!!

[@HowtoPowerBI]

thank you! this was actually a quick one, cause I was waiting for it to be there one day lol ( some others take me a looooot of time )

[@TenhoDados]

@@HowtoPowerBI Wow 🤯

[@filip3783]

Brilliant :) Power BI's Viz options are catching up to Tableau's beautiful Viz designs

[@HowtoPowerBI]

slowly getting there 😀

[@Anilkumar-fy4hs]

In a slicer visual we search for a keyword in the result we get 10 or 20 , results how can we select all the results in a single click. Is there any possibility to do that??

[@texmexdragon2160]

How did you get that pop up dialog box that shows the emojis? The one you used to create the delta triangle? Is that a native keyboard shortcut?

[@HowtoPowerBI]

Windows key + . (Period)

[@Ali_Shakh]

as always very helpful videos , really liked it 👍 p.s. when you first said ERROR BARS, I was like what is ARAB BARS ? 😅

[@HowtoPowerBI]

Yea i m trying to promote my new product arab bars ;)

[@JoseVelez-dhumonio]

BRUHHHH SO COOL!

[@HowtoPowerBI]

😎👊

[@Rothbardo]

Anyone figure out how to make the colors dynamic for the error bar circles in the second example?

[@jhcoburn1]

Got my chart in! Looks TOP NOTCH! I can control the hover over effect by turning off the tool tips or adding a tooltip page, but , Any suggestions on how to handle all the Placeholder data when you right click "Show as Table"

[@HowtoPowerBI]

that's awesome 🎉🎉 I don't think there is a good solution for that just yet. You could hide it, but I guess you still want it but just without the dummies

[@jhcoburn1]

OK, " Stayed Tuned" is fair! Thanks for the quick response! @@HowtoPowerBI

[@letbloodline]

All those dummy measures could be declared with the new feature in the visual or there are some limitations?

[@HowtoPowerBI]

the visual calculations? yes, that would work!

[@gintomino4136]

So smart. Nifty

[@HowtoPowerBI]

thanks!!

[@IsaiahDiaz-wr8rw]

how should the data be structured for this

[@LifeNFood]

Can we do this for current vs Previous, I am trying the same but I am only getting previous month info only example Feb data only not the difference between Jan and Feb

[@HowtoPowerBI]

Month vs month would also work, all the same logic as in video

[@ogejasper7038]

Hey Bas, how did you create the Metrics folder on its own? - 1:43

[@HowtoPowerBI]

Clean up your DAX measures with MEASURE TABLES and FOLDERS in Power BI kzbin.info/www/bejne/mXjRiIOrlpKWo9E

[@navyanagavlli7406]

I have updated to current version still for me reference line option is not showing

[@HowtoPowerBI]

it s on the analytics tab for you (right next to formatting) .. or you turn on on object under preview options and it looks the same as mine

[@ExcelWithChris]

Please please help. Power Query. Somewhere I saw you can get a result in a step, then export that result to another query, come back to this query and ref the step before "exporting" and carry on with the current query.

[@EmileDavis]

Hey there, I think I've done this before. The trick was instead of the query being a query end product, you convert it to a list. Removing the starter stuff like Let... and the In stuff at the bottom I think will achieve this. You then have a list that allows you to reference any of the steps in another query.

[@mohamedsobhy9947]

a greate vedio Could you share file as pbix plz

[@HowtoPowerBI]

See download link in description

[@DFact13621]

Where is the overlap now? Can't see it anymore in bars layout

[@Psyresidente]

I have Feb 2024 version but can't see Reference Line option

[@danishjameel6709]

Now I am going to change few graphs of my customers and my boss would be wow 😂😂

[@HowtoPowerBI]

:p and was the reaction as you hoped for lol 😁😊

[@872_revatipatil9]

Why is the reference line tab not available in my chart?

[@HowtoPowerBI]

Just different layout for the formatting options. I have under preview ob object formatting on. In your layout it is on de analytics tab right next to formatting

[@bhargavreddypalagiri8967]

How to enable overlap options in power Bi Desktop 12:44

[@CallumLawn]

There's no doubt these look great, but for a large enterprise with a thin report setup it's totally impractical to have this many measures required for one visual. In my case I have a model that serves 120 reports, this model naturally already has 1000's of measures. Do you have any visual best practice guides which account for these instances?

[@narendrababu2287]

❤

[@HowtoPowerBI]

☺️

[@niaaaawtf]

hello! New to power bi and I wanted to say even though I have the new update I can't find the Reference line

[@niaaaawtf]

I have the Feb 2024 version

[@HowtoPowerBI]

turn on object on under preview options .. or go to the analytics tab to add a constant line

[@niaaaawtf]

​@@HowtoPowerBI Thank you so much

[@rajishn]

The reference line option is not seen in my power bi

[@HowtoPowerBI]

Go to the analytics tab or turn onobject formatting on to have the same menu latout

[@rajishn]

@@HowtoPowerBI got it .thnks

[@wexwexexort]

Looks cool but the rendering the visual took really long for me. It's not the case when I use the same measures without the lollipops. Also creating the visual took some time, I wish powerbi just add these options efficiently and easily as core visuals.

[@HowtoPowerBI]

maybe try zebra bi cstom visual , easier to create a chart like this one .. not a native visual though

[@deepakkalavikatte]

Is it clusteeed bar chart

[@HowtoPowerBI]

Yes

[@ArtfulData]

The trick enhancess the visual appeal of Power BIdashboardsh creativity! Thanks

[@datavizuals]

Wow the click tax is insane - and he got every single one correct. The average user is clicking on every second sub menu trying to find the right place to make a formatting change.

[@HowtoPowerBI]

😉it's edited , also I click on the wrong stuff sometimes

[@shubhojeetchatterjee1369]

Please make a clustered box plot with this new feature

[@HowtoPowerBI]

same technique .. if you want to have different colors you could still add another dummy that conditionally shows for a certain category in a different color

[@Baldur1005]

When you go with first chart the amount of workarounds applied gave me headache :D

[@HowtoPowerBI]

Lol 😂. Its the same trick though, applied 10x

[@jcharlescribiu]

Bas tu devrais te faire embaucher par Microsoft Design !

[@HowtoPowerBI]

merci! Je ne sais pas cependant si c'est quelque chose auquel j'aspire ;)

[@edwinarchico439]

Perfect,

[@HowtoPowerBI]

Thank you!!!!😊

[@DianHrozek]

Great! But guys at ZebraBI probably are not gonna be happy. They have been selling those visuals for years.

[@HowtoPowerBI]

thanks! aaah still not as easy to get their as with their visuals. don't think they r too worried yet

[@chrism9037]

Awesome Bas!

[@HowtoPowerBI]

thank you!