Trend Visualization in Power BI

Рет қаралды 40,481

Күн бұрын

In this video I go over all the steps to create an arrow chart in Power BI without having to rely on any custom visual.
Enjoy this video 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:45 Creating the starting points for the arrows
02:48 Conditional formatting work around
04:59 Adding the arrows up and down
07:51 Adding labels to show change or current period value
10:26 Adding labels to show % change
13:16 Repositioning the % labels in the middle
18:08: Adjusting the sorting order
19:18 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 KZfaq: 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

Пікірлер: 85

@elishmuel1976 8 ай бұрын

Dude, your videos are A+. I've shared your channel w/ multiple colleagues at work.

@HowtoPowerBI 8 ай бұрын

aaaah thats where all the views r coming from ;) thx a lot! 🎉👊😎

@HugoOliveira-vs6wt 7 ай бұрын

These sound and image effects you're adding to these videos, some might argue they are so extra and pointless 🤣🤣 but not me, I find them somehow satisfying. Keep it up!

@alexgry4763 Ай бұрын

Bas is not covering Data Modelling and DAX topics. But this channel is the place to go if you want to learn about visualization and get some good taste. Best content for this!

@HowtoPowerBI Ай бұрын

Actually i cover a lot dax / pq / modeling .. you just probably missed those vids… here r some suggestions: Making DAX Easy kzfaq.info/get/bejne/qbV9m9SSxr2xaY0.html Exploring the SEMANTIC MODEL in Power BI kzfaq.info/get/bejne/gq-Sg7SXpqnKe40.html

@alexgry4763 Ай бұрын

@@HowtoPowerBI You do talk about DAX and you are very proficient with it. But it is not you primary focus and that is not a critique. On the contrary! All I know about PBI comes from 3 teachers. Ken Puls taught me PowerQuery. Alberto Ferrari and Marco Russo taught me DAX. You are the third and the most important teacher, since you taught me how to make visually appealing reports, how to bend Power BI and how to use it creatively. You can substitute the lack of knowledge of m and DAX with python and some clever SQL subqueries. But the best calculations in the world are useless if they end up in a sloppy and ugly dashboard. Therefore your content is a must-see for everyone who is into PBI.

@josefedericopresno6668 8 ай бұрын

Awesome video again, Bas. Thanks a lot!

@laiqmehdi8704 8 ай бұрын

Yours is most underrated channel but praying for the best for you god bless you always one day you will get billion of view inshallh you deserve alot and your videos are helping alot many

@alexgry4763 Ай бұрын

He will

@christinelowery2415 8 ай бұрын

I love these videos. You have taught me so much!! Thank you!

@HowtoPowerBI 8 ай бұрын

Glad you like them! 😁

@svapneel1486 6 ай бұрын

Fantastic Content. Very Useful. Thank you

@MS-sb3gv 8 ай бұрын

Great stuff! Appreciate you going through and attempting various solutions

@HowtoPowerBI 8 ай бұрын

😎👊

@rowanschoultz1022 8 ай бұрын

Thank you Bas. Very innovative!

@brightonalbert3237 8 ай бұрын

thank you, every day I learn something new thank you

@HowtoPowerBI 8 ай бұрын

thats awesome 😎👊

@alexmarvin3093 8 ай бұрын

that is so much work for so little aesthetic... worth it!

@HowtoPowerBI 8 ай бұрын

lol 😅😂 also wish it was easier sometimes

@jcharlescribiu 8 ай бұрын

Tu es trop fort🤯, merci pour tes vidéos, c'est très clair et presque facile à reproduire 😋.

@HowtoPowerBI 8 ай бұрын

mercii!!

@Myriam-sx5bf 5 ай бұрын

Really inspiring videos!! Thanks for that :) sometimes, soundeffects are a bit loud, if you ask me

@Kim-um5tz 8 ай бұрын

Hi Bas, great videos! I was wondering if it were possible to create a survey poll in powerbi?

@RobertoStaltari 7 ай бұрын

I admire how you can bend stock visuals to your will

@imxltf 8 ай бұрын

Fabs as always Master! Thanks for the course! 👏💃

@HowtoPowerBI 8 ай бұрын

😁thx for watching!

@PeterKontogeorgis 8 ай бұрын

Never cease to amaze Bas! Pushing error bars to the limit!!!

@HowtoPowerBI 8 ай бұрын

THANKS! 😁 yes, great feature for all kinds of work arounds

@Lgp2111 8 ай бұрын

Hey, what a nice video. i have difficulities find the "error bars" format menu, should set something in order to have the "error bars" in format menu??

@isospinofficial 7 ай бұрын

That's awesome Bas! Is it possible to create scalable measures to automatically calculate variance between time periods based on the visual layer selected when a user drills down and up on the date dimension? (e.g Year, Quarter, Month etc). Cheers

@datayoda74 8 ай бұрын

Another banger BAS. You are awesome.

@HowtoPowerBI 8 ай бұрын

🎉😊

@HappyAnalysing 8 ай бұрын

Hi You’re so good in designing a new visuals using the default power bi visuals which looks like a 3rd party visuals. Can you please do a video on Org chart on power BI for HR Data.. when there 30+ employees with 4+ levels in data feed. I tried to search in you tube.. didn’t find any useful video on this.. please please do a video on this.. this will be very helpful to many people. Thank you so much for all the videos that you’re doing❤

@HowtoPowerBI 8 ай бұрын

nice idea, let me think if there is a way to achieve that

@darthges25 8 ай бұрын

that would be really helpful!

@RohithN10 8 ай бұрын

Thanks! Such a Useful visual

@HowtoPowerBI 8 ай бұрын

Glad you think so!

@victorsalaspsalas3119 8 ай бұрын

you are great I love your videos

@HowtoPowerBI 8 ай бұрын

Thank you so much 😀

@anthonycipolla8630 8 ай бұрын

Excellent work❤ thank you 😊 what's your favourite visual Bas?

@HowtoPowerBI 8 ай бұрын

uuuuhmmm .. in power bi I would go for a line chart. It is simple, easy to understand, a go to visual for almost any report, can be modified into different visuals (like in this vid or boxplot etc), has more analytical features that you can add compared to most other visuals in pbi

@sarveshdeshpande1772 8 ай бұрын

Great learning 🫡

@HowtoPowerBI 8 ай бұрын

Thank you 🤗

@ChannelRush-id4yx 8 ай бұрын

Simply awesome

@HowtoPowerBI 8 ай бұрын

Thanks a lot 😊

@arbazahmad7177 8 ай бұрын

Excellent 🎉 thanks for sharing..

@HowtoPowerBI 8 ай бұрын

thanks for watching!!! 😁

@user-fr6hq7wn8p 8 ай бұрын

i have a table where there are ratings for each name, the rating column named as monthly, quaterly and yearly each column has a separate comments column named as month_rating_comments, quarterly_rating_comments and so on , i want to create a table visual where if i hover on the specific rating it will show me only its particular comment using a tooltip

@mogarrett3045 8 ай бұрын

excellent

@HowtoPowerBI 8 ай бұрын

thank you!!! 😊

@TheJoshtheboss 8 ай бұрын

Such a great channel, Bas. Top notch!! Btw, are you Turkish? My Turkish colleague has a very similar accent. So just wondering....sorry for assuming 🙂

@HowtoPowerBI 8 ай бұрын

Thank you 😊 no that’s a Dutch accent you’re hearing ;)

@TheJoshtheboss 8 ай бұрын

@@HowtoPowerBI Oh okay 😄. Really enjoying your videos. The best for Power BI there is 👍

@jessicafaust2748 7 ай бұрын

Not looking through all the comments, but for that complaint about not being able to change the decimals, I would modify the DAX to use ROUND and just drop the decimals.

@user-hc7vo1pi5h 8 ай бұрын

hey, I guess you could make this possible like when you click on one slice of pie chart it expand to whole pie chart into that slice color... If it is achievable provide some solution.

@zorankrekic3006 8 ай бұрын

Nice, what if I have and Revenue, can I show both Sales and Revenue, point next to point

@datareggibi 8 ай бұрын

Wow Awesome Bas

@HowtoPowerBI 8 ай бұрын

Thanks ✌️

@Aquaelus 8 ай бұрын

*He is Back*

@HowtoPowerBI 8 ай бұрын

😎👊

@juanignacioXI 8 ай бұрын

Great Work Bas, i suppose that visual is not dynamic right? So the filters will not work.

@HowtoPowerBI 8 ай бұрын

thanks !!! :D .. should be dynamic, why wouldn't it react to filters ?

@juanignacioXI 8 ай бұрын

@@HowtoPowerBI i mean that if You change of quarter and a value was below but now is above it would change of red to green?

@umermeer7959 3 ай бұрын

RESPECT +

@HowtoPowerBI 3 ай бұрын

👊😎

@brightonalbert3237 7 ай бұрын

thanks, can we do this with other quarters not the calendar year quarters

@HowtoPowerBI 7 ай бұрын

yes

@brightonalbert3237 7 ай бұрын

Any leads I guess I have hit a snag with CQ and PQ

@myareeves7082 7 ай бұрын

The error label is overlapping with my data. For the negative ones the dot goes right through the label so it's hard to read.

@myareeves7082 7 ай бұрын

the triangles aren't switching direction based on whether it's trending up or down for me

@cutesidra9885 8 ай бұрын

Hi Bas ur tutorials are awesome.plz need help Plz tell how to use power app for free. In someone's videos it says make 365 account for free then use that email in power app.plz tell is this the right way? If not then what to do.i can't pay for this

@manikantabalusa6896 8 ай бұрын

What if current and previous values are same and growth results nearer to zero ?

@tosinopeniyi1407 8 ай бұрын

I love it

@HowtoPowerBI 8 ай бұрын

🎉😁 thank you

@Myriam-sx5bf 2 күн бұрын

In my case the arrows from the error bars from the negative values show in the wrong direction. Thy also point upwards but they should point downwards as they do in your showcase.. what am I doing wrong???

@Myriam-sx5bf 4 сағат бұрын

Ok got it!! I switched lower and upper bound in the error bar section :x Thanks for the great video and the example file!!

@chandanamb9061 3 ай бұрын

Hi how do I do it if I want to check the trend for a date range..

@HowtoPowerBI 3 ай бұрын

You can check the measures in the download file.. see link in the description

@jaycobgray4450 8 ай бұрын

When I change it to a line graph, I don't see the option for error bars withing n the visualization tab. What could this mean?

@HowtoPowerBI 8 ай бұрын

you can turn on on object formatting under options, preview. Or you can go to the analytics tab (next to formatting) and set up the error bars from there

@myareeves7082 7 ай бұрын

I had this problem. It's the magnifying glass.