I just love this guys with all the out of box thinking to solve problems
@HowtoPowerBI11 ай бұрын
😊
@chu145211 ай бұрын
I just got a job that required power BI skills, maybe 80% all of my work will be using this bi tools, just subscribed and looking forward to watch all of your vid sir lol
@jade19976 күн бұрын
I have a chart that have 119 items, and this definitely stepped up the visual, thank you so much! Looking forward to the upcoming transformation training in a couple of weeks!
@inderr7bajaj11 ай бұрын
How did you even think of this? Unimaginable... Excellent mate...
@charliemather336811 ай бұрын
Beautiful solution!! One concern is that the maximum value of the axis changes based on the filter context. I would recommend creating a measure for the maximum axis value based on ALL dealers so as you filter the lower ranked dealers would continually decrease in bar length.
@HowtoPowerBI11 ай бұрын
that makes sense - good idea 😊
@suchitrapanicker972811 ай бұрын
@@HowtoPowerBI I'm looking for this. If you can solve this, I'd really appreciate it.
@JoaoCarlos-qg5cn9 ай бұрын
The amount of creativity here is incredible
@lukeminikoski11 ай бұрын
Awesome! Over 5-6 months without watching any video about PBI front-end and YT showed me this incredible opportunity! Thanks!
@FunnerMovies11 ай бұрын
You make the best Power BI tutorials… BY FAR!
@texmexdragon21609 ай бұрын
Awesome Bas. You are a genius at coming up with solutions that are not obvious or not available natively in Power Bi. I feel like the Microsoft Power Bi team should consistently check in on your videos for ideas that they should then incorporate into Power Bi as standard functionality. Save us from creating so many additional measures just to accomplish these very useful tricks and tips.
@itchy513511 ай бұрын
this is impressive. Please keep these videos coming. Thanks to you, my boss is impressed by "my" work :D
@tpaddock89111 ай бұрын
Another one of those things that should simply be supported natively, but great work in crafting a slick solution! I'll have to find a project to make us of this technique.
@HowtoPowerBI11 ай бұрын
yea that would nice! 😁 .. lets c if the dev team checks my vids
@datareggibi11 ай бұрын
Hello man, I'm new to the channel, but I've already become your fan, the content is of the highest quality.
@HowtoPowerBI11 ай бұрын
Welcome aboard! 😁😊
@anujchaudhari792011 ай бұрын
You are just amazing with power BI... 🤗
@HowtoPowerBI11 ай бұрын
thank you 2x 😁
@ayehtunaung693311 ай бұрын
Your tutorial brings me next level, and also have self-confidence. That I had been trying about this solution for past two months ago because our clients want to get selected items range on specified page. Now I will give the solution to my clients and also feel good. I am so impressing on you, and you get the brain from God. Thank you and waiting for more helpful tips and tricks about power bi.
@olamartins11 ай бұрын
Great content. I respect your logical reasoning and creativity. You're making power BI report like a web designed interface. Kudos
@slowchrno11 ай бұрын
Another amazing videos Bas! Thank you! Do you have any plans on making videos about the mobile formatting? My bosses love opening the reports through their cell but I find the mobile options to make reports so lacking. A video about mobile design would be great!
@TheBoussadra16 күн бұрын
Everything you do gives me ideas for my dashboard, thanks
@HowtoPowerBI15 күн бұрын
Happy to hear that!
@user-fc9ey8jl1u11 ай бұрын
Hi Bas! Look where your teachings have reached - all the way to Brazil. Immense gratitude for your guidance. When you decide to visit this side of the world, please let me know so we can enjoy some coconut water or, even better, a cold beer with a tropical flavor. May God continue to bless you always!
@user-zy1jr4xs9k2 ай бұрын
Dude, you may are one of the top out there. Got so many insights and ideas from your videos! Thank you,really!
@HowtoPowerBIАй бұрын
thx!
@BuddyLongLegs11 ай бұрын
Can't wait to try this. You always create awesome solutions!
@HowtoPowerBI11 ай бұрын
😎👊 have fun
@juanm55511 ай бұрын
It's 5 am here in Colombia... Bas video, time to learn!
@HowtoPowerBI11 ай бұрын
Awesome 😎 it’s never a wrong time :)
@regiscarneiro903211 ай бұрын
Hi Bas! here in Brazil, following your content. Very rich content. Thanks for sharing 🚀
@chukachukwu11 ай бұрын
Bas the legend, as usual another masterpiece
@rajuv3616Ай бұрын
Excellent workaround!
@nimikajadav30045 ай бұрын
Bas !! You are awesome man. I have learned a many things from your channel. and yes seriously I loved it.
@Igarpe9 ай бұрын
Brilliant! You always have solutions for tricky problems. Great work Bas!
@NikoSuomiUlkoilee4 ай бұрын
Brilliant! Round of applauses!
@quackquack4624 ай бұрын
one of the most helpful video ,nice work keep up ,love to watch your videos whenever i have time.
@hsrinivas7974 ай бұрын
I'm pretty sure that, even the people who developed Power BI software, don't know how to do this. It requires alot of deep understanding and experience.
@marcelamedeiros37442 ай бұрын
Baaas… ur creativity has no limit! Paginate that!
@sergiomyers20311 ай бұрын
love your content, always presenting fresh ideas to design reports, I appreciate it a lot, thank you.
@HowtoPowerBI11 ай бұрын
thank you!! :D 😊
@mobean7811 ай бұрын
This is amazing! I've never thought about providing a solution by manipulating a visual like this. Thank you for sharing this!
@remyberino11 ай бұрын
Thanks Bas for all the resources you've shared, another great illustration of what you can do with Power BI. Your videos help me to improve every time!
@anujchaudhari792011 ай бұрын
You are just amazing with power BI...
@HowtoPowerBI11 ай бұрын
thank you 1x 😁
@aletbamford100411 ай бұрын
You explain things very well. Thank you
@HowtoPowerBI11 ай бұрын
really nice to hear that Thank you!!!
@palanimathi449310 ай бұрын
I love your work brother, I learn lot from your videos. Thanks a lot
@tomaskavicky10 ай бұрын
mate, your videos starting to be even higher on my list than those from SQLBI :)
@juancastaneda93716 ай бұрын
S-Class instructor.
@HowtoPowerBI6 ай бұрын
🏎️ 🏎️🏎️😎😁 thx
@Tubasnot11 ай бұрын
Fantastic video, thank you so much for this content. Amazing what you can do with a little bit of knowhow and trick!!!!
@HowtoPowerBI11 ай бұрын
Glad you enjoyed it! 😊😎
@markhenderson377111 ай бұрын
Brilliant. Very creative. Thank you for sharing. You often demonstrate outcomes that I didn't know were possible to achieve. Thanks again.
@HowtoPowerBI11 ай бұрын
thank you Mark 😊
@wisid9 ай бұрын
this is just simply amazing, clever use of rank and slicers
@HowtoPowerBI9 ай бұрын
😊 thx
@pahadianalyst11 ай бұрын
I was waiting for this....let's goooooo
@HowtoPowerBI11 ай бұрын
Lets goooo 🏃
@kedarpande11 ай бұрын
You always come up with amazing Tricks
@steffverbraeken68311 ай бұрын
Waauw, your creativity keeps amazing me. Keep up the good work!
@HowtoPowerBI11 ай бұрын
Thank you so much 😀 definitely will
@androidgingelbread85225 ай бұрын
You are great! Thank you so much! 😊
@FernandoRamosOstroswky11 ай бұрын
Amazing!!! Ty for divide your knowledge with us! your video arrived here in São Paulo, Brazil...TY
@HowtoPowerBI11 ай бұрын
I was there 3 years ago! awesome , happy to hear my videos now make it all the way to São Paulo 😁
@JoaoCarlos-qg5cn9 ай бұрын
This tutorial is fantastic; I've successfully applied it to my dashboard. I'd like to share a useful tip from my experience. In my scenario, since my visual included filters, using the ALL() function caused it to overlook the #1 rank. To address this, I switched to using ALLSELECTED(): Item Rank = RANKX( ALLSELECTED( Sales[ShopName]), [Total de Produções UnB] ) However, this led to a new issue: without using ALL, every page displayed the same ranking. To resolve this, I modified the Item Rank Label as follows: Item Rank Label = IF( '# Pages'[# Pages Values] = 1, [Item Rank] & "°", ( '# Pages'[# Pages Values] - 1) * '# Items'[# Items Values] + [Item Rank] & "°")
@sharkillsbear11 ай бұрын
WOW! This video is full of amazing concepts. I'll be able to use pieces of this and the whole concept in my work right now! Thanks for always posting such great videos!
@HowtoPowerBI11 ай бұрын
awesome, great to hear that 😎
@brettwilson379511 ай бұрын
Great idea, something I have been looking for. Another useful learning Bas
@user-wl7lp4xr8p11 ай бұрын
Soooooo good!!! So empowering. I feel like this 🧗♀️😁😁😁🙏🙏🙏🙏🙏
@Haithamz11 ай бұрын
Creativity ⭐
@leegarrett190811 ай бұрын
Work of art! Keep it up. :)
@tiosamrj9510 ай бұрын
you are th boss man
@desenterrados20226 ай бұрын
This is sooooo GREAT!!! F****G GREAT!!!!
@HowtoPowerBI6 ай бұрын
😎👊
@geineralbertomejiagarzon403411 ай бұрын
Just an awesome tip for a great UX. Great.
@dannyvandenbroek11 ай бұрын
Thanks a lot, really awesome approach and I'm going to use it
@muhammetmuslu442911 ай бұрын
it is impossible to keep up with you. Great, while I was making a matrix table recently, I thought why there is no such feature in Power. Thank you very much.
@marymargaret872411 ай бұрын
U r genius, bless u for sharing ur knowledge with us, i had a Q- can we make slider vertical? plz do a video if we can thanx
@HowtoPowerBI11 ай бұрын
thanks for watching! Not completely sure what you have in mind. You can take a slicer, switch to tiles and adjust the with so that the items appear below each other vertically
@RichardOliver11 ай бұрын
Excellent solution, Bas. As always!
@HowtoPowerBI4 ай бұрын
thank you so much!!
@jebarajantoni753110 ай бұрын
Amazing ❤
@axan600011 ай бұрын
Wonderfull
@gustavobarbosa90611 ай бұрын
Excellent! Thank you!
@HowtoPowerBI11 ай бұрын
Glad you enjoyed it!
@edwinarchico43911 ай бұрын
Excellent work, you have a big part in my power bi journey🎉
@HowtoPowerBI11 ай бұрын
nice! happy i could help a bit on your pbi journey
@delidolux6 ай бұрын
Awesome, perfect tutorial.
@AessamL11 ай бұрын
This is SUPER cool!
@HowtoPowerBI11 ай бұрын
😎👊
@xvanadx11 ай бұрын
Excellent tutorial Bas. You are doing amazing job 👍
@HowtoPowerBI11 ай бұрын
Glad you think so! 😁😊
@jaymehta332011 ай бұрын
This is awesome! Thanks for sharing.
@arbazahmad717710 ай бұрын
Stunning ... thanks for sharing this valuable things.....🎉
@HowtoPowerBI10 ай бұрын
Thanks so much 😊
@unnikrishnansanthosh11 ай бұрын
one more from the Master BlASter, thank you for sharing
@OmarAl9311 ай бұрын
Brilliant
@Aquaelus11 ай бұрын
Our Boss is Back with new Dopamine
@HowtoPowerBI11 ай бұрын
🏋️♂️💪😎😁
@anilyadav-rt4sr10 ай бұрын
Wow super
@scottbradley119411 ай бұрын
brilliant
@maryampour891411 ай бұрын
Thanks for an amazing content as always 🙂
@devashishjain549311 ай бұрын
Beautiful, very useful feature and very well explained.
@HowtoPowerBI11 ай бұрын
Glad it was helpful! thanks for watching! 😊
@VicentePerdomoGarzon11 ай бұрын
Que bien, lo volvere a ver
@HowtoPowerBI11 ай бұрын
double thanks for watch it twice 😁😎
@dineshmaurya788411 ай бұрын
You are awesome man!! Where do you get such ideas, seems like piwer bi is a fun game for you😅
@nickvanoort960911 ай бұрын
Great video Bas! Always prompting video's right when they come in handy :D Looking to get it working for table visuals as well
@danielakiomorita11 ай бұрын
Impressive! 👏👏👏
@ajinnadh75197 ай бұрын
super bro
@ayubsherif589811 ай бұрын
beautiful stuff
@fabiokyrilloss11 ай бұрын
Great solution, Bas! I tried to implement it, but when a category filter is applied it breaks the visual. Is there any work around?
@moisesgonga130211 ай бұрын
Thanks for share 🎉🎉🎉🎉
@HowtoPowerBI11 ай бұрын
Welcome thanks for watching:)
@adityaprastio697227 күн бұрын
super
@rexramirez897811 ай бұрын
Genius!!
@mureedabdullah344410 ай бұрын
💚 Proposed improvements: - calculate a rank with RANKX but filter out zeros and blanks. rankMeasure = VAR temp = SUM ( Table1[Value] ) RETURN IF ( temp = 0, BLANK (), RANKX ( ALL ( Table1[Name] ), CALCULATE ( SUM ( Table1[Value] ) ) ) )
@MaorAviad11 ай бұрын
Amazing content as usual. Do you have a video showing A-Z complete project with all the latest features + connect to database ?
@stuartjohnson-haigh621011 ай бұрын
Great video, thank you. Could you do a video expanding on this to give the user the option to how they want to sort ie by sales value or by total items or by supplier etc please
@MoeBig502 ай бұрын
Genius
@HowtoPowerBIАй бұрын
Thank you!!!
@gpozzi.11 ай бұрын
¡Gracias!
@HowtoPowerBI11 ай бұрын
that's so nice - thanks for your support !!! 😊😁
@gpozzi.11 ай бұрын
@@HowtoPowerBI Very well deserved! The content you make is invaluable, both the quality of the recording itself and the value of the ideas you come up with Keep up the good work!
@kalyandeepak3789 ай бұрын
Excellent video bas, i have used several of your videos in my projects and they have really been helpful. One question from me is what's the advantage of using this over actual paginated reports visual?
@MichaelDoigАй бұрын
I noticed when converting the graph to a tablix and attempting to make pagination happen with multiple columns, very unexpected behaviours start to occur. Just the two columns (Dealer and Sales) does seem to work with a tablix visual. This would be elite if we could offer pagination for a standard tablix with say, 15 columns. Additionally, going back to this particular visual, if you had a Dealer with no sales (lets say they were closed) then it can trigger a blank record which could in turn trigger a pagination link with nothing on that page. Would have to add a condition to check for Sales > 0 somewhere.
@GabrielCosta-wn1wt7 ай бұрын
That's amazing! Does it work similarly with tables/matrixes? Or is it better to just use the paginated reports in that case?
@HowtoPowerBI6 ай бұрын
yes that would work in the same way. Like you say, you need to check what would be a better solution in your case .. either the paginated reports visual or like in the vid
@MichaelDoigАй бұрын
I'm finding that if you keep just the Dealer and the Sales columns, it works fine. Start adding more columns, as you would with any tablix, and things start getting weird.
@kiranmane85149 ай бұрын
Very useful trick thanks 👍 How do you handle the situation where items have same rank?
@pulkitgaur443810 ай бұрын
@HowtoPowerBI, Can you make a videos on how to steps PowerBI like your workspace, Like you have vertical tool bar at the right !
@shivmantra14065 ай бұрын
Hello Bas, Hope you can take a look at this. How will the Ranx work with Field parameters?
@kuzog573711 ай бұрын
How does that big brain fit in that head of yours? Great video.
@roxasdracun86614 ай бұрын
Had some issue that on the visual it will show 1 like below the bar after applying filter, but wasnt sure what to do as I was trying to do it more than two bars like if for example car Dealer -> Sales & Net Profit. Wanted so it could filter between those two Or I wanted to compare the sales and filter by month and do the ranking
@sushantshinde92996 ай бұрын
You are awesome, could you please tell me how to sort columns in matrix table ?
@HowtoPowerBI6 ай бұрын
Thanks 😊 here you go EVERYTHING YOU need to know about SORTING in POWER BI kzbin.info/www/bejne/imfTZquvaJqIhqc
@NandagopalB4 ай бұрын
Luckily i have subscribed you.. its very interesting. Instead of static # number items.. can we dynamically update based on the y axis distinct count . And show a lable that #number of items available to enter in that show items fields. Its my thought.