Power BI Slicers - A Step-by-Step Tutorial for All Types to Improve Data Analysis

Рет қаралды 177,972

Күн бұрын

Get access to our popular FREE Power BI QuickStart course today 👉 link.xelplus.com/yt-d-slice-p...
⭐ If you're ready to become a Power BI Pro, join our "Fast Track with Power BI" 👉 link.xelplus.com/yt-d-visuals...
Slicers in Microsoft Power BI are visual filters to narrow the portion of the dataset that is shown in report visuals. Simply put, with Slicers can let the viewer of your report choose the type of data that they want to see on the report. Managers love this feature. They can slice and dice.
Slicers make Power BI reports more interactive and let the user focus on the information they want. In this video, I'll share some great slicer options and how you can completely change the way slicers look in Power BI. You can have slicer buttons, slicer drop-down, slicer list, range sliders, timelines, and even a hierarchy inside the slicer. You'll learn how easy it is to set this up in power bi step by step.
🌍 Join 400,000+ professionals in our courses: www.xelplus.com/courses/
00:00 How to Use Slicers in Power BI
00:31 How to Make Slicers Look Like Buttons
02:31 List & Hierarchy Slicer
04:47 Drop Down Slicer
05:03 Range Slider for Numeric Slicer
05:52 Timeline Slicer
07:14 Bonus: How to Sync Slicers Across Multiple Pages
08:40 Get Access to Full Power BI Course
08:51 Wrap Up
🎬 LINKS to related videos:
- Should You Learn Power Bi? Everything You Need To Know: • Should You Learn Power...
- How to use Drill Through in Power BI: • How to use Drill Throu...
➡️ Join this channel to get access to perks: / @leilagharani
👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com/
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: www.xelplus.com/course-quiz/
🎥 RESOURCES I recommend: www.xelplus.com/resources/
🚩Let’s connect on social:
Instagram: / lgharani
LinkedIn: / xelplus
This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#powerbi

Пікірлер: 84

@LeilaGharani Жыл бұрын

If you found this video helpful, you're going to LOVE my FREE Power BI QuickStart course 👉 link.xelplus.com/yt-c-beginner-powerbi-freecourse Updates to Power BI: The December 2022 release (Power BI Version: 2.112.603.0 ) brought long awaited changes to slicer settings. You no longer have to worry about slicer types next to the slicer header and orientation on the format pane. Now it’s all in one place. Simply go to Format visual > Slicer Settings > Options > Style. The “horizontal” button slicers are now simply called tiles.

@staceyl.thienel1499 Жыл бұрын

Once again, you don't disappoint!! I'm getting ready to heavily get into PowerBI and will be reviewing this and your other videos! THANK YOU FOR ALL YOUR TUTORIALS - PowerPoint, Excel, etc. I hope to be able to suggest Simple Slides for my work!! Creative yet professional

@chh8860 Жыл бұрын

Soooo many options .... sooo many ideas .... and STILL sooo much to learn. Thank you ... thank you ... thank you .... 😍😍😍

@shubhamaggarwal6746 Жыл бұрын

Hi leila, Your way of explaining is really good and on point. I never knew that slicers could be this useful in data visualisation on BI.

@andrew_hubbard Жыл бұрын

Thank you! The part about syncing slicers across pages was very useful. I've done it myself, but I always copy the slicer and then select sync from the popup message box that appears when you do that. I'd not thought of doing it the way you showed which is a great way to get the slicer to affect other pages without having to copy the slicer. I will remember that for future reports.

@Mike-In-O-Town Жыл бұрын

Been around a long time and taken tons of coursework on a myriad of subjects/products, but I think your approach to teaching is terrific. I do not currently work with Power BI but I've really enjoyed your videos allowing me to get my feet wet on just how it works and what it can best be used for.

@LeilaGharani Жыл бұрын

Wow, thank you!

@zomnipotential 6 ай бұрын

Magnificent!! I had searched a lot before I noticed your page, and in the matter of a minute, my problem with how to add a field to the slicer and modify if was solved. Thank you so much!

@user-xh8cr9pk5g Жыл бұрын

Great video! Especially the syncing part of the slides across pages!

@vijayarjunwadkar Жыл бұрын

Thank you Leila! I am going bit slow on your Power BI course, in which I enrolled due to workload, but these intermittent Power BI videos are surely helping me out. I am really happy to see the same prowess in Power BI you have, as in Excel! Keep up the great work! 🙂

@LeilaGharani Жыл бұрын

Thanks, Vijay! Hope you're enjoying the course so far.

@vijayarjunwadkar Жыл бұрын

@@LeilaGharani Yes, I am! 👍

@andreashermle2716 3 ай бұрын

Leila, you are a terrific teacher. Keep up the good work

@Ticky66MN Жыл бұрын

Wow...this really opens up so many possibilities for me in my work. Thank you so much for all the wisdom you share with us.

@LeilaGharani Жыл бұрын

You are so welcome!

@labelleaffairs Жыл бұрын

All the way from Nigeria, you have been a source of inspiration for me. Keep up the good works

@unnikrishnansanthosh Жыл бұрын

simple and clear, thanks for sharing

@ivystutorial 3 ай бұрын

Thank you, simple and easy

@alburradasaddam3199 Жыл бұрын

All thanks and appreciation

@penugudurushiva Жыл бұрын

Wow, great explanation and really useful 🙂 thanks

@mahendragupta2512 Жыл бұрын

Excellent presentation!!

@rluo462 10 ай бұрын

love all the tutorial videos!!! clear and easy to follow

@LeilaGharani 10 ай бұрын

Awesome, thank you!

@alaamousa8208 Жыл бұрын

excellent & simple as usual

@Susiechoco Жыл бұрын

Great explanation as always

@user-wc4yc6ol8l Жыл бұрын

Fantastic thanks!

@julienbouillot6960 Жыл бұрын

Great video as always so nicely explained. Thank you! perhaps a topic for another video but I'd be curious to know if it is possible to use a text rather than a value when using card function. For instance if a sales value is in the top quartile, rather showing a number like 75% It could say top quartile. it's very easy to accomplish in Excel, was wondering if it was possible in power bi.

@georgepandiaraj2857 Жыл бұрын

Thank you for your clear and simple instructions! I have learned a lot from your videos. I have a question please: What software/App do you use to create your presentations? Thank you

@iqbaliba Жыл бұрын

Awesome as usual

@silvestrecamposano6317 Жыл бұрын

Thank you very much!..

@atanasprodatanasov9233 Жыл бұрын

Personally I like the chiclet one from the "get more visuals". It has really cool formatting options.

@Khan-mc3gi Жыл бұрын

Great work pls make one and complete video on background design colour this is backbone of power bi

@chrism9037 Жыл бұрын

Wow! Excellent video Leila, thanks

@LeilaGharani Жыл бұрын

Thank you! 😃

@shanabenjamin8945 2 күн бұрын

Thank you ❤

@sserubiricedrick9874 Жыл бұрын

Hello Leila, Thank you so much for the good work, we really appreciate it. Kindly create for us Introduction to python"lessons as well.

@mazchen Жыл бұрын

That was a really nice summary!

@LeilaGharani Жыл бұрын

Glad you liked it!

@Zorro.Arslan Жыл бұрын

Hi leila. Thanks for the great tutorial. Can’t find video about preparing data sheets before start in powerBi. Thanks

@imadsemsom1258 Жыл бұрын

Fantastic! Thank you But how to squeeze the slicer boxes as I always have to select the arrow to get the other boxes!

@MrAgide Жыл бұрын

Keep up good work very helpful

@osamasaid8476 Жыл бұрын

god bless you. thanks

@the_legends1989 Жыл бұрын

Hi Leila, From which table we should add columns into slicer eg. Dimension Table or fact table in case of one to many relationship

@simonraju3555 Жыл бұрын

Loved it

@larryjackson9646 Жыл бұрын

Thanks!

@LeilaGharani Жыл бұрын

Thank you Larry!

@ieuancilgwri9587 10 ай бұрын

Hello Lelila - thank so much for this - - - - can you set a slicer so that it impacts on another slicer? So in my example, I have a slicer for two categories, when I select one I expect it to reduce or remove categories in the second slicer I have on my page - so selecting Europe, as opposed to Asia - should only show European Cities in my next slicer? I hope this makes sense

@xue7159 Жыл бұрын

Hey Leila! Love your course! Do you have any discount on your fast track power BI couese? Merry Christmas!

@hamzamohammed3684 Жыл бұрын

I learned from the video

@emilymalkin270 4 ай бұрын

You did not mention advanced slicer syncing via groups. I was looking for that.

@hemvaidya Жыл бұрын

amazingly

@a.b.8444 Жыл бұрын

Hi Leila, Is there an option to insert/embed html code in PowerBi report, or maybe on Dashboards? I have some idea regarding vessels report, and I saw on web for tracking vessel that there is an option to insert tag into WEB pages to have that vessel map embed. Now I want to know if I can insert this code into PowerBI? EDIT: I try to insert tile on Dashboard with WEB content and I enter code in code section, but it doesn't show me (map with vessel position) anything on tile besides title.. BR, Ante

@user-qc3vw3nn4u 9 ай бұрын

Can we use a slicer to switch between two dataset for a graph (e.g. piechart)?

@nellieang Жыл бұрын

I want to have my slicer on time of the day only, say between 3:00pm and 5pm, using the BETWEEN setting. When i set up the slicer and linked it to my time table hour:minutes:00 am/pm column, the slicer displayed a calendar for 12/31/1899 apparently because the first time is 0 or 12:00:00 am

@alessandrodaniel1541 Жыл бұрын

Hello! How to change the colour of the rubber (to remove the filters) in the top right side of the slider? I can’t find the option!

@Wozzuup Жыл бұрын

Hi I have a problem with numeric slicer. I put a low and high value for this slicer from the filter pane and when I move the slide to the limit my data is not filtred with my own limit but with the maximum of the original values of the slicer

@christiandionne7596 Жыл бұрын

OK do you have a video on basic slicer set up? I am struggling with 1 excel file with 3 tabs of data. I want a slicer that I can select a supplier and show the spend done got that. No I want to also for the same selected supplier show their on time deliver from tab 2 data set.... I cant see to get the slicer to see the chosen supplier and show just their data. Rather is sums up the total on time delivery for all suppliers......

@chintandholakiya Жыл бұрын

Can I get Excel pivot like timeline in Power BI

@gillallasaishekar174 Жыл бұрын

Do freshers get placed as data analyst after getting very good hold on Power BI tool ????

@jjsambac Жыл бұрын

Can you pls create a tutorial on how to create box plots in PBI?

@ufuksakar6080 Жыл бұрын

👏👏👏👏. So good 🏆

@LeNguyen-py3hg Жыл бұрын

My option slicer is only 3 options are Top down, Vertical list, Tile. How do I add Between option?

@pavanthorat8324 6 ай бұрын

I have one shape or icon , when i click on that i need to se all slicers which i created . Is that possible ?

@Content_Deleted. 9 ай бұрын

I am not sure what it is called but we have something which i guess is a slicer. it is empty and i can paste series of item numbers in that area and click filter button on the right top of that box and it filters all the data according to the item numbers pasted in the box.

@paulregret3180 Жыл бұрын

Do you have video for. Column 1 -100 names. Column 4 -50 names. I want to move matching names in column 4 adjacent to same name in column 1. Put the matching name in column 2. If no match do not touch the name in column 4. Leave unmatched in column 4

@user-es3ln1lb2m 2 ай бұрын

I use a clear slicers button but it does not work on my table when I select directly in the table. How do I make the table and slicers sync?

@JenMayB 3 ай бұрын

I have a problem where my drill through isn’t syncing with my slicers; it’s not clearing so when people go to select the slicer, it’s blank data because there’s still a filter due to the previous drill thru. Help!

@lylageorge1597 9 сағат бұрын

Leila Hi: Could you explain how to do all this in the new June 2024 release. I find it very counter intuitive. Nothing is obvious in this new release. I see the Button slicer, but no options to make it a list of check boxes or a date slicer etc. Please Help.

@andrewdutch4843 Жыл бұрын

How do I get two slicers appearing multiple times synced with themselves, but not each other?

@jaxxonbalboa3243 Жыл бұрын

Recently my home computer "died" so I got a replacement which came with Winn 11. Win 11 won't let me install Oracle's VM. Is there a fix or work-around for this issue? Thanks.

@ankurbajaj84 Жыл бұрын

My power bi slicer has day month & year but my published report shows slicer with day of the date also. How to remove that.

@farazchughtai Жыл бұрын

how can i download it on mac

@Susiechoco Жыл бұрын

May I request video for Calendar master

@coryng Ай бұрын

There's no option under slicer setting at all??? Need help....

@prajwalshetty2047 Жыл бұрын

👍

@thekdtalk3591 6 ай бұрын

Now Slicers upgraded to new and it doesnt work at all sadly. pls help

@mahendragupta2512 Жыл бұрын

Request you share the data file...

@JackoKrauser Жыл бұрын

We want the old thumbnail back 😢

@abeyoye4018 Жыл бұрын

you are very beautiful lelia😍

@mothertoad560 Жыл бұрын

My brain hurts 😂

@pcm1852 Жыл бұрын

First

@ismailolaideibitoye4762 8 ай бұрын

Hi Leila, That's a great teaching! Is it possible to have all tiles in the report on a slicer, whereby each tile is selected by clicking a slicer? I saw something like that in your video here: kzfaq.info/get/bejne/o9uip8icptGudKc.htmlsi=C_9jBKOd0-80bdt_. Kindly help on how to do that.