Build a Slicer Panel in Power BI Like a PRO - Part 2

[@luizhenriqueAlb]

You elevated the dashboard to a new level. This is now my favorite Power BI channel.

[@yourownkpi]

Wow thats awesome :D

[@andresfelipe4092]

You are literally a data and UX wizard. What an excellent job, congratulations!!

[@yourownkpi]

Wow thanks :D I appreciate it

[@kukeleku13]

This is the best filter pane video I've ever seen on KZbin. I always felt Power BI is really lacking proper filter options for end users. Your solution is everything I wanted it to be.

[@yourownkpi]

Thanks, that's amazing to read :D Yeah Power BI is primarly not a design tool and it has a lot of limitations. But I think it's catching up nicely and they keep adding new features.

[@Hollow42K]

This may be the best filter pane on KZbin, great job!

[@yourownkpi]

Ah :D I really appreciate it!

[@samchs222]

you are turning a raw data guy to someone that can build appealing dashboards. Thank you very much!

[@yourownkpi]

Glad you like it!

[@samchs222]

I actually deployed something similar as an added feature to a published report. First, I asked my stakeholders that are mostly just about the raw data if they liked it and they were happy to have it

[@vijaydahake4388]

Thank you brother, its really a very knowledgable session, hats off!!

[@spen2431]

Just brilliant. Thanks for taking the time to share. 💥💥👍👍

[@yourownkpi]

Thanks haha, Im happy to share it

[@jade1997]

this helped my dashboard look so neat and tidy, thank you very much!

[@yourownkpi]

Glad it helped!

[@bartmalfait30]

You and Bas are truly the master in Dashboard Design in PowerBI, this is just top notch content!!!

[@yourownkpi]

That's really motivating, thank you 😊

[@surajthakkar3420]

I also just watch him and Bas for inspiration.

[@mnedix]

This is amazing, I can't wait to put it in practice. Thank you for the knowledge bit :)

[@viniciusfranciscodeoliveir432]

Awesome content! Can't wait to apply this number feature

[@yourownkpi]

Thanks! Im glad it was helpful :)

[@surajthakkar3420]

Amazing video as always mate!!!! thank you!

[@yourownkpi]

Glad you enjoyed it :)

[@lucienallard9835]

First of all thank you for your content which is very helpful. I may have missed someting tho because when I am using my app in power BI, I sometime click in the shape of the panel instead of the slicer and panel then come in front en hide the slicers. Do you have any idea on how to fix this ? Thanks again.

[@Eyi_]

Hi, this is very insightful, thanks a lot. Quick question, do I have to repeat the whole filter creation process on every page/tab I have? I tried copying and pasting but it takes me back to page 1 and filters only the data on that page. How can I solve this issue?

[@yourownkpi]

Youre welcome :) Yes you have to set up the bookmarks on each page individually

[@sripadGangakhed]

Amzing

[@gulcecuruk6025]

First of all, thank you for this video. I have a question. If we don't want to show the filters applied with "Filters on all pages", is it possible to only display the filters applied through the slicer on the dashboard?

[@midegageorge5170]

Now this is awesomeness!!!

[@tingyuliu3943]

Amazing contents. Cheers mate!

[@RobertoSilva-yv7yy]

Great :) congratulations!!

[@pejhana5865]

Great work. You really do your best with the dashboard UX. I wanted to ask did you use a custom visualization for the table? I tried my best with the tables in PowerBI but the still look rigid as heck. Do you have any tricks up your sleeve?

[@yourownkpi]

Thanks :) No it's the native table and I used a shape for the header background. You can check out how it's been built in the download file

[@StefanB903]

This is really great and I'm new to Power BI, but trying to find my way. One question I have, I cannot get this filter correctly set if I'm using DATE, any solution/ idea for this

[@yourownkpi]

Great to hear :) What doesnt work correctly exatly?

[@antoniofelez4674]

Awesome filter man!! I noticed when I select a single column value in a table visual the counter is activated and it shows a count of 3, and in some other visual like pie chart, it would show count of 2. Any solution to this?

[@yourownkpi]

Thanks! Thats a good point. What I can think of is to disable the interaction between the visuals in which slicer data is used. In the example it would be necessary to disable the interaction from the two column charts in the direction of both the filter counter and the button itself

[@scottjezard6447]

Hey, this is great stuff thanks. FYI when you say "height" it is pronounced like "hi-t" not "hey-t" ❤

[@yourownkpi]

Oh thanks haha. I learned it once badly and saying it that way ever since 😩 I hope not to forget

[@shlokjain4493]

Hello, I like this video alot , but I have one question if I make a filter pane and filter the options and if i Have a power APP tool so will the filters remain unchanged ?

[@yourownkpi]

Hey thanks :) I can't really tell you, I'm not familair with the Power Apps

[@chilladas]

Good Job. Can't wait for part2. The filter bar will be interactive?

[@yourownkpi]

Thanks. There will be a tooltip in it showing the selected values for the active filters.

[@Krishna-md1pl]

Waiting for next part video Upload fast ❤

[@yourownkpi]

I try my best :)

[@jawadahmadehssan6251]

Great work. Thank you

[@yourownkpi]

Glad you liked it!

[@zoo101station]

hi. recent subscriber here. Question, at 8:07, how did you pick up and copy the blue color? I checked the Power BI documentation, and I can't seem to find the keyboard shortcut for that. TIA!

[@yourownkpi]

Welcome to the channel 🤗 I just had it somewhere saved and copied it with Ctrl+C Ctrl+V haha

[@zoo101station]

@@yourownkpi Ha ha! I thought you were using a color picker since I could not find the keyboard shortcut. Nevertheless, still an amazing tutorial, learned. a lot. Thanks!

[@yourownkpi]

I also use a color picker quite often. There is a cool one in the PowerToys bundle from Microsoft and you can pick any color from the screen. Its also free :)

[@Excel_and_PowerBI]

Very interesting

[@hanankhalifa2589]

I love your designs ❤

[@why_so_sirius]

Awesome stuff

[@francisthegeek]

Amazing!

[@zc16jnunez]

you are by far my favorite powerbi developer right now, you have clean easy code and good minimalistic aesthetic with good color pallets hard to find people that have that all combined.

[@yourownkpi]

Wow I really appreciate it :D

[@cesart4257]

Great work on this! Applied this logic to one of my key dashboards. Bravo!

[@yourownkpi]

thanks amd Im glad it helped :)

[@enanbahadur88]

Always inspired by your work Zsolt, thank you so much for sharing.

[@yourownkpi]

Thats great to hear and youre welcome :)

[@lokenathmukherjeekol]

Was looking for this thank you Zsolt....

[@yourownkpi]

Youre welcme :)

[@UnifiedCodist]

just wanted to say that your videos are awesome!

[@yourownkpi]

Thanks! very much appreciated :)

[@Steven140695]

you make my day bro, incedible 👏👏👏

[@yourownkpi]

Happy to hear that :D

[@mushfiqulislam8898]

i learned a lot. as a new power bi user. thanks

[@yourownkpi]

Youre welcome!

[@reddysekhar459]

Thank you so much! Great🙏

[@yourownkpi]

Thanks for watching :)

[@zoo101station]

CTRL + D, powerful!

[@yourownkpi]

💪💪

[@UPerfil1]

The best, great job!

[@yourownkpi]

Thanks a lot!

[@HenriquedeAlbuquerque-x1x]

I am looking forward for part 3, 4, 5 and the other new videos you will make. May I suggest something? in your example, the result for the tooltip does not appear in alphabetical order, therefore I added this and I am sharing in case you'd like to use it. CONCATENATEX(Filter_Table,[Value] -- [Value] é o nome default da coluna a tabela virtual , "," -- Separator (optional) ,[Value] -- Sorting expression (optional) ,ASC) -- Sorting direction (optional) --------------------------------------------------------------------------------------------------------------- and before I forget: This video is incridible.

[@yourownkpi]

Thanks for the suggestion. That's also a good option. In my case I wanted to sort the slicer names in the same order as they are sorted in the filter panel. And before I forget thanks again :D

[@workstuff5253]

Great content - thanks!

[@yourownkpi]

thanks for watching :)