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

This is the second part of the slicer panel video series.
In the first video we built step-by-step a custom filter panel in Power BI and in this video we create a conditional button showing the number of active filters. It also shows in a tooltip which filters are active.
You can check the first part here:
• Build a Slicer Panel i...
⬇️ Download Power BI file (Part 2):
drive.google.com/drive/folder...
📸 IG: / yourownkpi
🖼️ Dribbble: dribbble.com/YourOwnKPI
👨‍💼 LinkedIn: / zsolt-szabo-bln
⌚ Timestamps
00:00 Intro
00:53 Add filter counter
03:52 Button formatting
12:36 Add tooltip
18:10 Outro
#yourownkpi #yokpi

[@jade1997]

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

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

[@andresfelipe4092]

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

[@yourownkpi]

Wow thanks :D I appreciate it

[@Hollow42K]

This may be the best filter pane on UA-cam, great job!

[@yourownkpi]

Ah :D I really appreciate it!

[@vijaydahake4388]

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

[@kukeleku13]

This is the best filter pane video I've ever seen on UA-cam. 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.

[@cesart4257]

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

[@yourownkpi]

thanks amd Im glad it helped :)

[@mnedix]

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

[@RobertoSilva-yv7yy]

Great :) congratulations!!

[@zoo101station]

CTRL + D, powerful!

[@yourownkpi]

💪💪

[@Steven140695]

you make my day bro, incedible 👏👏👏

[@yourownkpi]

Happy to hear that :D

[@UPerfil1]

The best, great job!

[@yourownkpi]

Thanks a lot!

[@hanankhalifa2589]

I love your designs ❤

[@surajthakkar3420]

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

[@yourownkpi]

Glad you enjoyed it :)

[@francisthegeek]

Amazing!

[@spen2431]

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

[@yourownkpi]

Thanks haha, Im happy to share it

[@UnifiedCodist]

just wanted to say that your videos are awesome!

[@yourownkpi]

Thanks! very much appreciated :)

[@jawadahmadehssan6251]

Great work. Thank you

[@yourownkpi]

Glad you liked it!

[@Excel_and_PowerBI]

Very interesting

[@reddysekhar459]

Thank you so much! Great🙏

[@yourownkpi]

Thanks for watching :)

[@why_so_sirius]

Awesome stuff

[@viniciusfranciscodeoliveir432]

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

[@yourownkpi]

Thanks! Im glad it was helpful :)

[@lokenathmukherjeekol]

Was looking for this thank you Zsolt....

[@yourownkpi]

Youre welcme :)

[@mushfiqulislam8898]

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

[@yourownkpi]

Youre welcome!

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

[@sripadGangakhed]

Amzing

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

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

[@Krishna-md1pl]

Waiting for next part video
Upload fast ❤

[@yourownkpi]

I try my best :)

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

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

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

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

[@workstuff5253]

Great content - thanks!

[@yourownkpi]

thanks for watching :)

[@user-bg7tw8xo7e]

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

[@enanbahadur88]

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

[@yourownkpi]

Thats great to hear and youre welcome :)