Trend Visualization in Power BI

[@elishmuel1976]

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

[@HowtoPowerBI]

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

[@laiqmehdi8704]

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

[@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 kzbin.info/www/bejne/qYCwmaSXlryAb7s Exploring the SEMANTIC MODEL in Power BI kzbin.info/www/bejne/gnrFgYScdqiZgbs

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

[@HugoOliveira-vs6wt]

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!

[@alexmarvin3093]

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

[@HowtoPowerBI]

lol 😅😂 also wish it was easier sometimes

[@brightonalbert3237]

thank you, every day I learn something new thank you

[@HowtoPowerBI]

thats awesome 😎👊

[@jcharlescribiu]

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

[@HowtoPowerBI]

mercii!!

[@josefedericopresno6668]

Awesome video again, Bas. Thanks a lot!

[@christinelowery2415]

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

[@HowtoPowerBI]

Glad you like them! 😁

[@Lgp2111]

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

[@svapneel1486]

Fantastic Content. Very Useful. Thank you

[@Myriam-sx5bf]

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

[@rowanschoultz1022]

Thank you Bas. Very innovative!

[@MS-sb3gv]

Great stuff! Appreciate you going through and attempting various solutions

[@HowtoPowerBI]

😎👊

[@imxltf]

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

[@HowtoPowerBI]

😁thx for watching!

[@HappyAnalysing]

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]

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

[@Miguelkonzen]

that would be really helpful!

[@datayoda74]

Another banger BAS. You are awesome.

[@HowtoPowerBI]

🎉😊

[@PeterKontogeorgis]

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

[@HowtoPowerBI]

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

[@victorsalaspsalas3119]

you are great I love your videos

[@HowtoPowerBI]

Thank you so much 😀

[@RobertoStaltari]

I admire how you can bend stock visuals to your will

[@TheJoshtheboss]

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]

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

[@TheJoshtheboss]

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

[@danishdani3768]

amazing!

[@sarveshdeshpande1772]

Great learning 🫡

[@HowtoPowerBI]

Thank you 🤗

[@Kim-um5tz]

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

[@brightonalbert3237]

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

[@HowtoPowerBI]

yes

[@brightonalbert3237]

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

[@isospinofficial]

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

[@Dnmac69420]

Amazing

[@ChannelRush-id4yx]

Simply awesome

[@HowtoPowerBI]

Thanks a lot 😊

[@RohithN10]

Thanks! Such a Useful visual

[@HowtoPowerBI]

Glad you think so!

[@Aquaelus]

*He is Back*

[@HowtoPowerBI]

😎👊

[@arbazahmad7177]

Excellent 🎉 thanks for sharing..

[@HowtoPowerBI]

thanks for watching!!! 😁

[@datareggibi]

Wow Awesome Bas

[@HowtoPowerBI]

Thanks ✌️

[@juanignacioXI]

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

[@HowtoPowerBI]

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

[@juanignacioXI]

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

[@jessicafaust2748]

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.

[@mogarrett3045]

excellent

[@HowtoPowerBI]

thank you!!! 😊

[@zorankrekic3006]

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

[@Myriam-sx5bf]

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]

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

[@cutesidra9885]

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

[@vaishnaviThakre-h2f]

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.

[@PriyanshChetani]

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

[@chandanamb9061]

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

[@HowtoPowerBI]

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

[@myareeves7082]

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.

[@Sololevelling12]

RESPECT +

[@HowtoPowerBI]

👊😎

[@tosinopeniyi1407]

I love it

[@HowtoPowerBI]

🎉😁 thank you

[@jaycobgray4450]

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]

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]

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

[@manikantabalusa6896]

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

[@myareeves7082]

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

[@explainspragmaticworks8477]

SELECTEDVALUE( Calendar[QuarternYear] 20213

[@rommelcaceres7730]

"Hello, I'm trying to do this but with weeks. Is that possible?"

[@alekseyivanov255]

feel your pain bro