This is brilliant BUT why is everything useful such a workaround in Power BI? Do Microsoft actually use it themselves and realize the shortfalls in it? Maybe Microsoft could implement all your suggestions into a simple set of options!
@RichardOliver2 жыл бұрын
Totally agree. The stuff Bas teaches us is great but, as he himself says, it is a lot of effort. I really appreciate his videos, though, as I think he is a great trainer.
@email2niranjan2 жыл бұрын
Same feeling
@christopherjohnson37552 жыл бұрын
In my opinion MS need to dedicate a few months if releases to just QoL changes, bug/annoyance fixes and achieving basic formatting parity with competing BI tools. Instead they will keep rolling out advanced stuff that sells licences but developers on the ground aren't really fussed about. This is a cool solution but one major problem is it won't sync across pages - only actual slicers or filters will do that.
@RichardOliver2 жыл бұрын
@@christopherjohnson3755 Ah, yes, good point about the syncing across pages.
@summer_xo2 жыл бұрын
Couldn't agree more.
@erikdessiex10262 жыл бұрын
Using a tree map as a slicer is such a genius idea, here I was using the vertical slicer and using this boxes which you cannot colour as you like it. Thanks !!!
@tMub3652 жыл бұрын
When I saw the tree map, I was like "ah Ha! Got you this time, Bas!.. Of course, I was wrong. Had to get my learning cap back on so fast! Thanks, Bas. Never disappoints.
@StarfiresDad2 жыл бұрын
THIS IS SO GREAT! 1. Great idea to use the treemap in such a way ✨ 2. Overcomes the limitations of the slicer when trying to drill through! ✨ Now we can make a "slicer" selection AND THEN drillthrough! AMAZING! THANKS, BAS! ✨🙏🏾✨
@StevePaine19862 жыл бұрын
This is really impressive... sir you are a genius! I've never considered using other visuals as a filter in this way. Brilliant!
@HowtoPowerBI2 жыл бұрын
thanks Stephen :)
@paulrockliffe23782 жыл бұрын
Cool video, thanks. I've done this before, though not with the explicit purpose of replicating a Slicer, but have a couple of thoughts; the reason I've used visuals as Slicers is because they contain context to suggest what filters you want. So with your Tree Map, if you don't use that Measure to force them all the same size, it's still giving you your slicer options, but also showing you which categories are more important. The main issue I've found is that clicking in the visuals resets all the other visuals in a way that it doesn't reset a slicer, so the slicer settings are more prone to being reset by accident. More of an issue if you have multiple visuals slicing a chart, but getting your users to remember to hold down Control when they make their choices is impossible!
@johngriffith7442 жыл бұрын
I've spent all day building a dashboard at work, I come home, watch this and instantly want to start 'playing' again. Great channel 👍
@HowtoPowerBI2 жыл бұрын
Hahah awesome, have fun!
@walteradamsbe Жыл бұрын
Hi Bas, In the current version of Power BI (April 2023), using the bar chart with tabular editor fix as you have demonstrated in this great video, doesn't work smoothly anymore. Or at least, that is to say, on the report I'm applying it too. in Power BI desktop, before this addition: no issues. Afterwards and when clicking on the bar chart items, I get an error message "Something went wrong - An error occurred while rendering the report" with the option to report this issue. It's unfortunate I can't get it to work properly because I really liked the flexibility this offered over the standard boring slicers.
@barttitulaerexcelbart94002 жыл бұрын
Thank you Bas! what you do in 20 minutes, ordinary people (like me) will use more than a day to figure this out! 😉
@brundleseth512 жыл бұрын
Great, the treemap works better as a slicer than as a treemap... Thanks 👍🏼👍🏼👍🏼
@danielalex46372 жыл бұрын
Wanted to take a few moments to share my appreciation for all your content. It's very useful and its expressed clearly, also love the thinking process you go through it to analyze possible solutions for one problem. Thanks!!
@HowtoPowerBI2 жыл бұрын
thanks Daniel, this means a lot to me! :)
@pilarbaldominos25052 жыл бұрын
Fantastic… it is curious thing is I had This exact problem a few weeks ago. (Unfortunately KZbin didnt show me the video when you published it) The way that I solved is using charticulator, which I found much easier than I though at the begging. Thanks for all your ideas!
@Avenger246012 жыл бұрын
This is my first video from this channel. It was easy to follow and informative. Thank you!
@manjunatharalikatti2202 Жыл бұрын
dazzling... This is great...
@shashankabhishek9557 Жыл бұрын
Awesome Sir. You are great in Power BI.
@rossanderson52182 жыл бұрын
it's like you've just shown me a really obvious thing, but also an really incredible thing at the same time that would never have thought off! mixed emotions haha superb though. subscribed!
@edwinjonah2 жыл бұрын
Really like the way you show your thought process and not just the final solution, nice work!
@Karthikediga2 жыл бұрын
You have an amazing talent.
@MyGhilli2 жыл бұрын
This is brilliant Bas. For the first time, I am seeing using treemap as a slicer. I am going to implement this ASAP. Thanks for sharing.
@michaeldouglas32002 жыл бұрын
Woou, if that is the easy way, I cannot imagine what you do in a more processed way. I´m just starting to use Power BI and I wanted to know how to change the format of the slicer to cubes as the first cases but I found in your video a more advanced format that exists. Thank you very much. I´m starting to follow you.
@othmanashara93822 жыл бұрын
Thanks, can you please tell how change orientation for slicer and P IB edition 8-2022. so all formatting general is different in the video.
@HowtoPowerBI2 жыл бұрын
Guess you solved this now :)
@othmanashara93822 жыл бұрын
@@HowtoPowerBI yes i did, when i saw one of your latest video. But I have a question : if i need more visuals P Bi asked to put company email or university, can i put a microsoft account ?
@joaorataoo2 жыл бұрын
Hello BAS, Another excellent demonstration of how it is not only important to know the product but have the skills and imagination to get what we want when it does not exist by default. Another functionality that we lose with this solution is the Sync Slicer. I would like to challenge you to create a series of videos using the Charticulator. Congratulations for your work. Thanks
@akusins2 жыл бұрын
Omg crazy solution with tree map, thanks Mate!
@HowtoPowerBI2 жыл бұрын
:):) you are super welcome!
@MrAstonmartin787 ай бұрын
When I use bar chart as a slicer - it doesn't filtering the other bar chart like slicer does. On other barchart I have in subtitle the measure (Fx) that shows total sum. And when I change cintext by slicer - it changes in a right way. When hihglited by bar chart "like a slicer" - it doesn't.
@FerencHarmann Жыл бұрын
Hi Bas, great video! how can i use this with field parameters?
@TheProjectCorner2 жыл бұрын
This is just pure magic. Awesome! Thanks for sharing great content Bas.
@2gheymanАй бұрын
You created a measure in a table called Metrics. Did you create a separate table just to put in measures?
@nocodeninja2 жыл бұрын
Great video and a nice alternative way to display slicers. BTW, what screen recording software do you use?
@avishek1984 Жыл бұрын
I want to build a slicer (single select radio button in the dropdown) whose presence will be controlled by another slicer. Let's say, I have 2 slicers with a single-click radio button dropdown. Slicer 1 gives an option between "Global" and "Local" and Slicer 2 gives an option between "Fixed" and "Variable". I want that when I select Global from Slicer 1, slicer 2 should appear, or the options of Slicer 2 should appear. When I select "Local" in slicer 1, slicer 2 should not show any option
@filippogermi16182 жыл бұрын
Super, you shows how to solve a problem on tending data that make me crazy, i've tried to replicate on my case unfortunately unsuccessfully, whatever my case is not so far (many trends of analyses value in one chart and i'd like to create selection that shows one or max 2 lines). Still need to learn more of PowerBI. maybe you cna give some more support?
@filippogermi16182 жыл бұрын
Willbe possible to link to the selection "slicer" a bookmark to activate/disactivate an hided image?
@qayyumkadri2138 Жыл бұрын
if I am not wrong we can't use this slicer to filter another page. I mean we can't sync slicer
@MiWolverine96 Жыл бұрын
Very innovative! Thank you!
@sabrinebenlaabidi68182 жыл бұрын
Awesome! Very nice Idea I'll try it ! 😁 Thank you 🙏
@DookyButter2 жыл бұрын
Bas, you put out some kick-ass content!
@VladMZ2 жыл бұрын
This is awesome! I have no idea why I didn't think about this before! Why didn't you use a table as a slicer?
@rajeshghosh5688 Жыл бұрын
Love from India❤
@mehdihammadi61452 жыл бұрын
Thanks Bas, I so few days ago the trick of using the Treemap visual as a slicer but you did a very deep review of the possibilities. Thanks for sharing
@HowtoPowerBI2 жыл бұрын
thanks Mehdi! yeah we posted it originally here www.linkedin.com/feed/update/urn:li:activity:6865603835243569152 but improved the solution afterwards :)
@chengwang4112 жыл бұрын
A touch of genius. 👍
@kindakhalaf7509 Жыл бұрын
the treemap is genius! thanks!
@ammarqureshi8955 Жыл бұрын
Brilliant! I was struggling to have colored slicer but this is simply creative. Thank you. Any chance if I can somehow wrap text in the treemap?
@AHMEDALDAFAAE1 Жыл бұрын
You always come with a new idea!! Thank you!
@thiagodmxtube Жыл бұрын
Huge fan of your tutorials, keep up man, cheers.
@HowtoPowerBI Жыл бұрын
Thanks a lot Thiago :)
@abelnyamori2 жыл бұрын
5 minutes in and this is brilliant! Amazing video and I’m not even a third of the way in yet
@HowtoPowerBI2 жыл бұрын
:):) glad you like it Abel!
@DrSugarrr Жыл бұрын
Omg! I come from graphic design world and... it is ridiculous how you lack control over visuals (and fonts!) in PBI lol. I wish Adobe and Microsoft would team up on upgrading PBI's design features. You have amazing tips on how to get around that, though, it is much appreciated:)) Cheers!
@itchy51352 жыл бұрын
i just discovered your channel and thank you, sir. These are all fantastic aids as I'm new to PBI so i'm soaking everything in.
@HowtoPowerBI2 жыл бұрын
Awesome Chris! Welcome to the channel and all the best for your Power BI journey then :)
@humorislife89512 жыл бұрын
This hack got me to subscribe mate !
@gabriellandinez9441 Жыл бұрын
This is just amazing. thank you
@DEMONTmx2 жыл бұрын
Wow, this one just blew my mind, thanks for all the content, hopefully Microsoft updates Power BI soon
@monicatanasescu2 жыл бұрын
What a great idea! I guess you could use a similar approach to achieve the much needed option of displaying labels from another measure?
@seonggi-hun7482 Жыл бұрын
Clever solution. I’ll definitely use this!
@granand2 жыл бұрын
Bro is at different level .. He is absolute gem
@HowtoPowerBI2 жыл бұрын
thx that's really nice to hear! 😀😊
@viratalaparthi2506 Жыл бұрын
Hello Sir, that’s a brilliant hack. I have tried implementing the same after watching your viseo, and somehow filtering using bar chart changed the format of values in other visuals. Any help?!
@SuhasPassionated2 жыл бұрын
Excellent! Thank you
@tomipedelaborde Жыл бұрын
You´ve helped me a lot my bro thanksssssssssssssssss
@tubeitz2 жыл бұрын
absolutely brilliant
@hebahmeidan66802 жыл бұрын
How did you made the category column with relation to data?
@user-ze4xc6tu4f2 жыл бұрын
u are power bi visual magician
@scottwilliams67412 жыл бұрын
Love the tree map solution! Great video Bas!! Wish I had seen it earlier.
@HowtoPowerBI2 жыл бұрын
Thanks Scott :)
@RoxanaSulea Жыл бұрын
Brilliant! Many thanks
@mubbashshirkhan47422 жыл бұрын
What if I want to select multiple values using tree map slicer
@MYOB9902 жыл бұрын
What we need is a slicer that you can filter to show only a subset of the large set. And, I may have missed it, but WTF with there not being a function that returns just the current date? Everything brings back a date time and you have to jump through hoops to extract the date, If I'm wrong,. please, please enlighten me..
@oricchannel28112 жыл бұрын
Another great video with very useful tips and tricks. Thank you for sharing.
@NaveenKumar-hd3yg2 жыл бұрын
Hi I have one doubt In my dashboard have one table, one card , on slicer is there and my question is when i am selecting the slicer no need to change card only change table is it possible?, How ?.
@gregday90932 жыл бұрын
Copied step by step the bar chart slicer and did not work after re-watching multiple times. Do you know if this is still working?
@Acheiropoietos2 жыл бұрын
I usually count categories by 'distinct' always gives 1 for the tree map size x - your bar chart solution is genius though, I'll be stealing that on Monday.
@_Rodrigo_2 жыл бұрын
excellent information!!! nice!!
@anmanubu2 жыл бұрын
Hello, thank you very much for this tip. But I have a question, I was trying this in a column bar chart, but the variables that are not selected don’t disappeared, they stay in a lighter color. Do you know how can I fix that?
@SSRealEstates83 Жыл бұрын
It's amazing...I almost got the output...but facing a small road block. On the bar chart the product id is coming but...the I'd is getting add a 1 number to it... example...if the I'd 100 ....on the y axis it is showing 100 ...but on the bar chart it is showing 101....plz help...thanks in advance
@ebogart422 жыл бұрын
Wonderful information - Thanks! Going to use that treemap with hard-coded measure value for sure!
@HowtoPowerBI2 жыл бұрын
You are welcome! :)
@tacijjola2 жыл бұрын
Amazing. Thanks Bas! :) Love your videos! Extremely useful and contemplated. Much aprecated
@HowtoPowerBI2 жыл бұрын
Thanks a lot Jola :) much appreciated!
@arturgarncarz3631 Жыл бұрын
Nice video. I came up with something else. If you want to have a legend next to this chart with same colors but it SHOULD NOT filter chart next to it but other visuals on your page just make this bar chart without any legend. Make a second one with ONLY legend, place it next to chart one and deselect filtering in interactions. That way you will have a legend that works as a slicer but DOES NOT change chart next to it.
@erickknackstedt31312 жыл бұрын
Top stuff. Thank you!
@spen24312 жыл бұрын
...yet another 💥. Nice work Bas. Thank You.
@akshunithy Жыл бұрын
One query - If used 2 tree map and need to use both as filter.. How to do? For me it's not working
@unnikrishnansanthosh2 жыл бұрын
great ideas come from BAS, thanks a lot
@HowtoPowerBI2 жыл бұрын
:):)
@Luis.C.Canchan2 жыл бұрын
Hola Bass, eres increíble, muchas gracias por tus enseñanzas!!!!
@luca75tubo2 жыл бұрын
Thank you Bas. You are great!
@powerofmax222 жыл бұрын
Thank you for all, honestly
@athirab22122 жыл бұрын
Hi sir in my slicer I am not having the orientation field what to do?
@turnbullca12 жыл бұрын
Hey Bas, love the stuff you do and this is fantastic. If I wanted to use that as a slicer I would want the selections to be the same colour is that possible with a stacked bar
@angelaroi8332 жыл бұрын
Always fantastic tips and tricks, thank you!
@gagansingh34812 жыл бұрын
You are genius 👏
@HowtoPowerBI2 жыл бұрын
😂genius? I wish haha, just know a bit power bi 😉
@culpritdesign2 жыл бұрын
Dax is over complicated compared to excel functions or other bi tools like tableau or Sisense but power bi does some things really well
@rogeriopsvalle2 жыл бұрын
Great vídeo. Congrats.
@HowtoPowerBI2 жыл бұрын
Thanks a loooot! 🙏
@honeybee69782 жыл бұрын
Cool video... really brilliant idea to use a tree map as a slicer
@HowtoPowerBI2 жыл бұрын
Happy to hear you like this idea 💡:)
@JinghaoKe2 жыл бұрын
Nice videos!, can i check if you are using any tool to zoom into the window while presenting? Is it post production or you can do it live, e.g. while sharing screen in a zoom meeting.
@HowtoPowerBI2 жыл бұрын
Thanks Jinghao :) the zooming, it is all post production
@motichoorladdu2 жыл бұрын
Thanks!
@HowtoPowerBI2 жыл бұрын
thanks for the support!
@sylau15162 жыл бұрын
Tried but there is a problem as it cannot show the data on the chart which may not fulfil the user requirements.
@abbastechtalks2 жыл бұрын
this is amazing. Thank your for sharing this.
@HowtoPowerBI2 жыл бұрын
You are welcome Abbas!
@user-ze4xc6tu4f Жыл бұрын
Treemap Slicer ! Bang!
@user-tb6vc2wx6i2 жыл бұрын
hello from Ukraine. Nice, thank you =)
@sokgat70192 жыл бұрын
Wow !!! Great work, thank you !!!
@picious2 жыл бұрын
brilliant !!!
@boonchaitiproongroj79592 жыл бұрын
I love the video. Nice trick👍
@HowtoPowerBI2 жыл бұрын
Thanks Boonchai
@2122Super2 жыл бұрын
Great stuff
@mnowako2 жыл бұрын
Excellent! 👏 Thank you!
@josehoyos2 жыл бұрын
Really creative .... Thanks!
@tammeynart2 жыл бұрын
Brilliant!!
@HowtoPowerBI2 жыл бұрын
thank you so much Nart! ☺
@lesliecox67852 жыл бұрын
I like this - but is there any way to add captions? I'm hard of hearing and not always catching everything you are saying. Great tips, though, from what I can catch!