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

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

[@Hollow42K]

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

[@yourownkpi]

Ah :D I really appreciate it!

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

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

[@yourownkpi]

awesome :) I assume you also enjoy doing it. the best way to overdeliver

[@Ilv2rid9]

This is awesome! Really appreciate your teaching style.

[@yourownkpi]

I appreciate that!

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

[@Akshay-z8t5f]

THE BEST ! Such a great help!

[@enanbahadur88]

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

[@yourownkpi]

Thats great to hear and youre welcome :)

[@vijaydahake4388]

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

[@ayoubserhani6347]

This is one of the best tutorials! Thank you so much

[@yourownkpi]

Glad you think so!

[@cesart4257]

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

[@yourownkpi]

thanks amd Im glad it helped :)

[@UnifiedCodist]

just wanted to say that your videos are awesome!

[@yourownkpi]

Thanks! very much appreciated :)

[@jade1997]

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

[@yourownkpi]

Glad it helped!

[@spen2431]

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

[@yourownkpi]

Thanks haha, Im happy to share it

[@mnedix]

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

[@midegageorge5170]

Now this is awesomeness!!!

[@mushfiqulislam8898]

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

[@yourownkpi]

Youre welcome!

[@tingyuliu3943]

Amazing contents. Cheers mate!

[@viniciusfranciscodeoliveir432]

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

[@yourownkpi]

Thanks! Im glad it was helpful :)

[@hanankhalifa2589]

I love your designs ❤

[@surajthakkar3420]

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

[@yourownkpi]

Glad you enjoyed it :)

[@Steven140695]

you make my day bro, incedible 👏👏👏

[@yourownkpi]

Happy to hear that :D

[@experience_kingsley]

Thank you! I am learning so much!

[@yourownkpi]

🤗

[@RobertoSilva-yv7yy]

Great :) congratulations!!

[@jawadahmadehssan6251]

Great work. Thank you

[@yourownkpi]

Glad you liked it!

[@lokenathmukherjeekol]

Was looking for this thank you Zsolt....

[@yourownkpi]

Youre welcme :)

[@UPerfil1]

The best, great job!

[@yourownkpi]

Thanks a lot!

[@zoo101station]

CTRL + D, powerful!

[@yourownkpi]

💪💪

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

[@reddysekhar459]

Thank you so much! Great🙏

[@yourownkpi]

Thanks for watching :)

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

[@why_so_sirius]

Awesome stuff

[@francisthegeek]

Amazing!

[@Krishna-md1pl]

Waiting for next part video Upload fast ❤

[@yourownkpi]

I try my best :)

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

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

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

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

[@Excel_and_PowerBI]

Very interesting

[@sripadGangakhed]

Amzing

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

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

[@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 :)

[@Franaman]

Maybe I am missing something but how can I keep the filters once I open the filter again because it works with a bookmark it will go back to the state it once was, so the user has to anyway select all filters every time they want when they open the filter bookmark? Or did I miss something somewhere

[@yourownkpi]

the hide show filter pane bookmarks should only affect the Display Visuals for selected visuals. Uncheck the Data in the two bookmarks and update them

[@workstuff5253]

Great content - thanks!

[@yourownkpi]

thanks for watching :)

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

[@daniyalnaveed861]

Only one word that came to mind after seeing this video i.e, LEGEND 🫡