Build a Slicer Panel in Power BI Like a PRO

Рет қаралды 64,966

Күн бұрын

In this video we build step-by-step a custom filter panel in Power BI which we can show and hide upon clicking a button. Besides saving a lot of space, it also enhances the user experience for the dashboard.
It is the first part of a 4-video-series on how to build a slicer panel. So stay tuned for the upcoming videos :)
⬇️ Download Power BI file (Part 1):
drive.google.c...
🎬Watch Part 2 here:
• Build a Slicer Panel i...
🚀 Do you want to create reports with a top-end design template quickly?
yourownkpi.gum...
📸 IG: / yourownkpi
🖼️ Dribbble: dribbble.com/Y...
👨‍💼 LinkedIn: / zsolt-szabo-bln
⌚ Timestamps
00:00 Intro
00:26 Build filter pane
07:52 Add buttons
14:22 Add bookmarks
19:55 Outro
#yourownkpi #yokpi

Пікірлер: 76

@yourownkpi 3 ай бұрын

Part 2 is out :) kzfaq.info/get/bejne/fZl3rM-dvafYYWg.html

@bigmo931 3 ай бұрын

Great demonstration and explanations. Even though it was a 20 minute video, I was engaged the entire time. Your explanations were concise and not drawn out.

@yourownkpi 3 ай бұрын

That's a great feedback, thanks! :)

@BbabbittGolf Ай бұрын

Yea this was great , I love the clean look of your work as well Thank you!

@yourownkpi Ай бұрын

Thank you too!

@leonsmall1051 10 күн бұрын

Awesome content. Thank you very much.

@ahashim610511 2 ай бұрын

Good job! Very clear, professional, and on point!

@user-bg7tw8xo7e 3 ай бұрын

Wow, congratulations! You've really created an incredible video. I can tell that it really held your attention the entire time

@yourownkpi 3 ай бұрын

Thanks for the feedback :)

@shubhamanand7564 3 ай бұрын

Just one word for this.. Perfect!! Thanks for this very useful demonstration. Waiting for the next part.

@yourownkpi 3 ай бұрын

I appreciate it, thanks for watching :)

@Acheiropoietos 3 ай бұрын

Very nice solution. It’s always a tricky balancing act between space for slicers and visual content.

@yourownkpi 3 ай бұрын

Exactly

@motasemfarhat 3 ай бұрын

I did it before 3 years ago.. anyway good job 🎉

@IyaboSindiku 2 ай бұрын

Great tutorial. Thank you for sharing

@yourownkpi 2 ай бұрын

Thanks for watching!

@jupitershorizons 2 ай бұрын

Great walkthrough! thank you!

@yourownkpi 2 ай бұрын

You're welcome!

@Datavoll 2 ай бұрын

Very nice I will implement it in my current project

@yourownkpi 2 ай бұрын

Great 👍

@hidekel7916 3 ай бұрын

Que buen tutorial doctor, un suscriptor más 🎉

@yourownkpi 3 ай бұрын

Obrigado 😊

@adrianocastro269 3 ай бұрын

Muito bom! Good Work. I'm From Santos City.

@yourownkpi 3 ай бұрын

Thanks 🤗 greetings from Berlin

@boston19801 3 ай бұрын

Brilliant tutorial

@AnshulMarele-gbaa 2 ай бұрын

JUST Ultimate 👌👌

@huyinh513 3 ай бұрын

Wonderful video, thank you!

@textnotepro 3 ай бұрын

What an excellent video. I have subscribed and I am looking forward to seeing how you do the counters for 'filters applied'

@yourownkpi 3 ай бұрын

Thanks, I appreciate it :) it is coming by the end of this week or the next week.

@readistreet9383 2 ай бұрын

great video!

@reddysekhar459 3 ай бұрын

Thank you! Awesome video 👌

@sdyclase 3 күн бұрын

increible

@blackbeard5237 3 ай бұрын

Thank you, and clean data too

@franklinv93 11 күн бұрын

Can the slicer panel be replicated in all the sheets of the power bi report?

@aswin131 3 ай бұрын

waiting for the next part

@yourownkpi 3 ай бұрын

Next part is out :) kzfaq.info/get/bejne/fZl3rM-dvafYYWg.html

@samirmendoza8507 3 ай бұрын

awesome! thanks for sharing!

@yourownkpi 3 ай бұрын

Thanks for watching :)

@mrTonYT987 3 ай бұрын

amazing, thanks!

@VivekDevalkar 3 ай бұрын

This is very beautifully done. However, what if we want the filter pan across multiple tabs? Would we need to copy on each tab and create a set of bookmarks for each tab?

@yourownkpi 3 ай бұрын

Thanks! Yes that is the case. You have to copy the visuals and create the bookmarks on the pages separately

@nikhilgurrapu1391 3 ай бұрын

When Close Button is press the Filter is cleared. The Filters should remain the same as selected by user but it clears the filters and closes. What's the solution?

@yourownkpi 3 ай бұрын

You have to uncheck the 'Data' when setting up the bookmark to not affect the slicer selections

@GauravGupta-ub9kr 2 ай бұрын

You can create another button and use bookmarks.

@yogieyo4779 3 ай бұрын

What ruler software used for that alignment red lines?

@workstuff5253 3 ай бұрын

Nice video = new sub! 👍

@yourownkpi 3 ай бұрын

Awesome thank you!

@nehabelives 3 ай бұрын

How to pass date parameter to direct query (dates should be taken forms slicer at specked value )

@jmwdba 3 ай бұрын

Beautiful but I hope Microsoft implements a way to make this a faster process with fewer steps in the future.

@yourownkpi 3 ай бұрын

Yes that would be cool haha

@Krishna-md1pl 3 ай бұрын

Awesome Make a video on dax ❤

@yourownkpi 3 ай бұрын

Thanks! Now Im focusing more on design and visualization videos but in the next parts of this filter pane series there will a lot of DAX :)

@Krishna-md1pl 3 ай бұрын

@@yourownkpi when slicer panel 2nd video release Waiting 🙂

@nelrosell1 3 ай бұрын

wow it's awesome, but just wondering if you can save the values of the slicers and later when you reload the report the values are still same?

@yourownkpi 3 ай бұрын

Thanks :) yes exactly that's what the bookmarks are for. You can preset some slicers and create a bookmark (make sure the Data is checked) and apply it to the visual. Whenever you navigate onto this bookmark, it will go to this sate of the slicers.

@nelrosell1 3 ай бұрын

@@yourownkpi yes I did that but when you refresh the report the slicers value got reset.

@yourownkpi 3 ай бұрын

if you want to have your slicers in a specific selection when you open the report, you need to save the file in that state. The report always shows the state you saved the file in, when your efresh the page

@ArtfulData 3 ай бұрын

Great

@Igor-oc4om 3 ай бұрын

is it possible to set the filter from the advanced filters pane in the same way, so that they are visible in the public announcement?

@yourownkpi 3 ай бұрын

Public announcment you mean when you publish the report? I'm also not sure what you are referring to by advanced filters pane. The default filter pane on the right side?

@Igor-oc4om 3 ай бұрын

@@yourownkpi Yes, public release of the report. In this case, the right eye of the filter is not visible.

@saojoaomeriti Ай бұрын

How can I can do that in networkdays (without Saturday and Sunday and holiday days) : Column Discunted days New Column Result 24/06/2024 -3 dias = 19/06/2024

@venkataakhilmanduri8354 3 ай бұрын

cool

@Desperatemeasuress 3 ай бұрын

What is the meaning of the close button if you have the X icon and vice versa?

@yourownkpi 3 ай бұрын

They do the same, closing the filter panel. It gives the user more than one option to close the filter panel to make it a bit faster. It's a common ui element and you can see it for example in the Windows popup dialogue windows too

@Desperatemeasuress 3 ай бұрын

@@yourownkpi you are right. Yet it doesn’t mean that is the best approach as Windows is not known for being user friendly. I would look at iOS as an example. Anyway that aside i love your videos and hope to learn more from you

@yourownkpi 2 ай бұрын

I never owned any apple products but definitely going to look into it. Thanks :)

@logocreative1694 3 ай бұрын

Hi want your little help in power bi If i create matrix table Those matrix table columns have names of employees and also manager's name now when i publish report when employees see that report they should see only their name The manager's name should not appear when the manager see the report Then everyone's name should appear It possible to we can create such a button in Power Bi, when the manager presses that button, a panel of password will appear and after entering the password, a report of employees include with manager names will appear.

@yourownkpi 3 ай бұрын

Are the employeee and manager names in the same column? In that case you can look into Row Level Security. With that you can filter the data and show different results diepending on which user opens the report. There is no need for password or anything, it happens automatically. kzfaq.info/get/bejne/g96FkqmKuLnSiYk.html

@logocreative1694 3 ай бұрын

@@yourownkpi Yes employee and manger name are in same column and 2nd column is score and manager don't want to see there scores to employees and manager want to hide score from other employees in matrix table but when publish dashboard manager open link then automatically manager see there own score but when employees open link automatically hide manager scores