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.
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! 🙂
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.
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
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!
Dear Leila It’s fantastic to learn from you. As always, you’re doing an amazing job. However, I have a quick question, if I may. I would like to use a timeline slicer for a chart. The thing that bothers me is that even though my data only has monthly intervals (like 01.01, 01.02, 01.03), the timeline slicer displays every day of the month (03.01 doesn’t really help me). Is there a way to adjust it so that only the monthly intervals are shown, just like in my data table? Best regards,
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.
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
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.
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
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.
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
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......
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!
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
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
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
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.
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: czcams.com/video/murtekAkJDs/video.htmlsi=C_9jBKOd0-80bdt_. Kindly help on how to do that.
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.
Soooo many options .... sooo many ideas .... and STILL sooo much to learn.
Thank you ... thank you ... thank you .... 😍😍😍
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! 🙂
Thanks, Vijay! Hope you're enjoying the course so far.
@@LeilaGharani Yes, I am! 👍
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.
Wow, thank you!
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.
You are so welcome!
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
Leila, you are a terrific teacher. Keep up the good work
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!
Dear Leila
It’s fantastic to learn from you. As always, you’re doing an amazing job.
However, I have a quick question, if I may.
I would like to use a timeline slicer for a chart. The thing that bothers me is that even though my data only has monthly intervals (like 01.01, 01.02, 01.03), the timeline slicer displays every day of the month (03.01 doesn’t really help me). Is there a way to adjust it so that only the monthly intervals are shown, just like in my data table?
Best regards,
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.
You did not mention advanced slicer syncing via groups. I was looking for that.
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.
Hi leila. Thanks for the great tutorial.
Can’t find video about preparing data sheets before start in powerBi. Thanks
Great work pls make one and complete video on background design colour this is backbone of power bi
Great video! Especially the syncing part of the slides across pages!
Personally I like the chiclet one from the "get more visuals". It has really cool formatting options.
All the way from Nigeria, you have been a source of inspiration for me. Keep up the good works
Can we use a slicer to switch between two dataset for a graph (e.g. piechart)?
Thank you, simple and easy
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
Now Slicers upgraded to new and it doesnt work at all sadly. pls help
Fantastic!
Thank you
But how to squeeze the slicer boxes as I always have to select the arrow to get the other boxes!
Hi Leila,
From which table we should add columns into slicer eg. Dimension Table or fact table in case of one to many relationship
Hello Leila,
Thank you so much for the good work, we really appreciate it.
Kindly create for us Introduction to python"lessons as well.
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.
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
All thanks and appreciation
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.
Thank you ❤
Hey Leila! Love your course! Do you have any discount on your fast track power BI couese? Merry Christmas!
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
simple and clear, thanks for sharing
I learned from the video
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......
love all the tutorial videos!!! clear and easy to follow
Awesome, thank you!
Do freshers get placed as data analyst after getting very good hold on Power BI tool ????
Thank you very much!..
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?
Excellent presentation!!
My option slicer is only 3 options are Top down, Vertical list, Tile. How do I add Between option?
That was a really nice summary!
Glad you liked it!
There's no option under slicer setting at all??? Need help....
Thanks!
Thank you Larry!
excellent & simple as usual
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!
Can I get Excel pivot like timeline in Power BI
I have one shape or icon , when i click on that i need to se all slicers which i created . Is that possible ?
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
Can you pls create a tutorial on how to create box plots in PBI?
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!
Wow, great explanation and really useful 🙂 thanks
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
How do I get two slicers appearing multiple times synced with themselves, but not each other?
May I request video for Calendar master
Great explanation as always
Fantastic thanks!
My power bi slicer has day month & year but my published report shows slicer with day of the date also. How to remove that.
Wow! Excellent video Leila, thanks
Thank you! 😃
Loved it
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
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.
god bless you. thanks
Awesome as usual
Keep up good work very helpful
how can i download it on mac
Request you share the data file...
Hi
Could please explain how to get access users with kind of slicer options
amazingly
👏👏👏👏. So good 🏆
We want the old thumbnail back 😢
👍
First
My brain hurts 😂
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: czcams.com/video/murtekAkJDs/video.htmlsi=C_9jBKOd0-80bdt_. Kindly help on how to do that.
you are very beautiful lelia😍
Mam can u plss share ur contact details... I have some excel related issues for which I have not got solution from many experts...