1 Trick for Endless Power BI Charts!
Вставка
- Опубліковано 29 чер 2024
- 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 support@datatraining.io
---------------------------------
⏱️ 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 UA-cam: 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 - Наука та технологія
This youtube channel does not talk about power bi, it's all about magic
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.
thank you! a fx button would have been nice though 😅😁
Awesome Bas! Nice method of setting the bar chart 🔥
😎👊
Awesome Bas, I have been waiting for these from ages.
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!
Superb work!!! This will be used on next assignment, much appreciated!!
New hands on Power BI, Your Tips have actually being a great inspiration. You do pure Magic there.
😎👊
This is so insane! Your video tips help me a lot. Many thanks Bas!
Happy to help! 😊thanks for watching them
Bas your creativity is insane! Thanks for sharing.
Awesome Bas ! By setting up a new chart using error bars, I am becoming a big fan. You have created a very nice visualization
Thank you for all the great tips and also thank you for wearing that shirt! 😍
Amazing! Really appreciate your pursue to perfection 🌟
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
ah perfect, especially for you a timed it like this 😋😉
Amazing work Bas!! Love your workarounds and little "hacks" for PBI 😊
Thanks! 😀
this video is very perfect！！！ thank you
excellent content man! as always
Appreciate it!
Awesome. I’m slowly learning with your contents as beginner.
why not fast 😋 .. awesome, happy to be part of your learning journey
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
awesome, thx for watching Paul
another incredible one from the Guru
😊😊😊 thank you
hat off = amazing Bas!
Excellent 🎉thanks for sharing 👍
Thank you! Cheers! 😊
Awesome Bas!
Amazing, such a creative approach to take advantage of every new features release
Do you have similar content also for Tableau?
Brilliant :) Power BI's Viz options are catching up to Tableau's beautiful Viz designs
slowly getting there 😀
Amazing lesson. Thanks heap.
Glad you liked it!
I love your chart 2, bravo 🎉
thanks!! 😁
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.
Useful on projects im working, bet for most others here too
nice trick. bravo. thank you for sharing
😊 thx
awesome! thanks for great content . one question: how do show outliers with this trick of yours
wow, it's incredible!
thanks!!!
Thanks, Bas! Had NO idea that Feb 2024 update snuck it in there. 😀 Miguel has been keeping himself busy, I see! 😉
visual calculations were getting the spot light this month lol ;)
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?
Brilliant ❤
Hey Bas, thanks alot for this amazing tutorial, I was wondering if there a way to add a variance % on the reference line?
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?
how ever, great video y content , just a question, it can do it , adding the var % , another vertical line side by side?
Best video seen today
hope it wasn't the first one then :p .. thank you!
as always very helpful videos , really liked it 👍
p.s. when you first said ERROR BARS, I was like what is ARAB BARS ? 😅
Yea i m trying to promote my new product arab bars ;)
Awesome! Other than Power bi, I want to learn "Editing" from YOU!!!
🙏 thanks , maybe for a different channel lol
Amazing
Awesome 👌
🙌
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
awesome!
😎👊
Nice!!
thanks! 😊
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")
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
Wonderfully incredible. I wonder how many hours you spend figuring out these tricks. Congratulations on the work!!!
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 )
@@HowtoPowerBI Wow 🤯
BRUHHHH SO COOL!
😎👊
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
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 ?
here you go ua-cam.com/video/cGnWPua-cmo/v-deo.html
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?
So smart. Nifty
thanks!!
I have updated to current version still for me reference line option is not showing
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
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
What screen recorder software did you use for your video?
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"
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
OK, " Stayed Tuned" is fair! Thanks for the quick response! @@HowtoPowerBI
The trick enhancess the visual appeal of Power BIdashboardsh creativity! Thanks
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
Month vs month would also work, all the same logic as in video
Anyone figure out how to make the colors dynamic for the error bar circles in the second example?
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??
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?
Windows key + . (Period)
All those dummy measures could be declared with the new feature in the visual or there are some limitations?
the visual calculations? yes, that would work!
Where is the overlap now? Can't see it anymore in bars layout
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.
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.
a greate vedio Could you share file as pbix plz
See download link in description
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.
maybe try zebra bi cstom visual , easier to create a chart like this one .. not a native visual though
how should the data be structured for this
Hey Bas, how did you create the Metrics folder on its own? - 1:43
Clean up your DAX measures with MEASURE TABLES and FOLDERS in Power BI
ua-cam.com/video/cGnWPua-cmo/v-deo.html
How to enable overlap options in power Bi Desktop 12:44
Now I am going to change few graphs of my customers and my boss would be wow 😂😂
:p and was the reaction as you hoped for lol 😁😊
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.
😉it's edited , also I click on the wrong stuff sometimes
❤
☺️
I have Feb 2024 version but can't see Reference Line option
Why is the reference line tab not available in my chart?
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
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?
Please make a clustered box plot with this new feature
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
The reference line option is not seen in my power bi
Go to the analytics tab or turn onobject formatting on to have the same menu latout
@@HowtoPowerBI got it .thnks
hello! New to power bi and I wanted to say even though I have the new update I can't find the Reference line
I have the Feb 2024 version
turn on object on under preview options .. or go to the analytics tab to add a constant line
@@HowtoPowerBI Thank you so much
When you go with first chart the amount of workarounds applied gave me headache :D
Lol 😂. Its the same trick though, applied 10x
Bas tu devrais te faire embaucher par Microsoft Design !
merci! Je ne sais pas cependant si c'est quelque chose auquel j'aspire ;)
Is it clusteeed bar chart
Yes
Perfect,
Thank you!!!!😊
Great! But guys at ZebraBI probably are not gonna be happy. They have been selling those visuals for years.
thanks! aaah still not as easy to get their as with their visuals. don't think they r too worried yet
Awesome Bas!
thank you!