Power BI slicers vs the filter pane (2021) 

Never even explored that whole APPLY option. That's why I watch these videos regardless of how 'basic' they may seem from the title. There is ALWAYS something new to learn!

excellent

The best thing about IT is the people.

Big downside to slicers for me is when it comes to users exporting reports as PDF or PowerPoint which does not reflect any changes made in slicer selection when generating the file. Using Filters works with exports so we have stopped using slicers to avoid confusion.

Oh! And hidden slicers with bookmarks are a great tool!

Well untill filter pane can be... filtered by measure, slicers win. Especially with big dimension table with many members which is not filtered(but should) by RLS.

Hi Guys! I'd like to see a video from you in the same vein about the filtering/cross-filtering impact on DAX statments i.e. ALL(), ALLSELECTED(), ALLCROSSFILTERED(), KEEPFILTERES(), etc.. I know from experience it's very easy to get lost in intentions vs. what is output from your measures.

Recently started playing around w/ Power BI and I love the vids 👍🏿 and p.s you have the best shirts!

Hi! Clients who are used to QlikView often wants to only se the filter options that will give you any hits. For example, if i choose 2021 from dimYear, my filter on product category from dimProduct is espected to only show the products who is sold so far in 2021. Its solved in Slicers with a Visual-only filter in filter pane saying only show post where my measure SalesAmout is not blank. Any thoughts here? Is that possible between dimensions (without ugly tricks as calculated columns in fact table with RELATED and then show filter from fact table)? Thanks!

Thank you so much - I was hitting my head against the proverbial brick wall trying to figure out how to limit the slicer filters to only certain visuals. This video solved it! One kind of annoying quirk (possible bug?) I found with this was that if you are trying to control interactions with several visuals of mixed types (for example, 5 cards + a bar chart), you have to click on your filter first and activate it *before* going to the interactions button and clicking on that to selectively turn on/off the interactions on each visual. In my case, initially I had the bar chart highlighted and when I went to the interactions button, the option to turn the filter off was not there, but it showed up for the 5 cards. I couldn't figure out why it wasn't giving me the option to turn the filtering off for the bar chart and it was simply an order of precedence issue.

Hiding slicers so they don't execute on page load.....Brillant!!

Hi Mr. Adam, do you have a technique or solution on how to use DAX or any other method using a button to set as a default the first record in a table visual in PBI. I have a table visual with a list of names with a add_date on the first column and want to make sure that when the user opens this page in PBI the first row is selected. I love your clarity and way of explaining things on technical solutions. Hope to hear from you soon my friend.

I liked the concept of APPLY option

Got here looking for a way to have two slicers to interact together in an OR configuration instead of an AND. Seems like it should be easy but I can not find it. Halp?

I have 1 question please do answer I have got 1 Google sheet that is connected with power bi and I want to connect two different dates columns into 1 so I can get the amount of patient reg and and amount of patients deceased and transfer patients in 1 slicer

Good comparison. One small detail I've noticed on my reports too - 3:01 - despite interaction being disabled, the table still "flickers" whenever the slicer value is changed. Not a big deal, just wondering what's the technical reason behind it.

Thanks, Adam. That was a helpful summary of slicers, filters , and how they work together (or not!).

Nyce! Let's do some sync slices!:)

Very much depends on the amount of data you are using and how its accessed.. What I'd like to see is how to group slicers to impact data displays.. for example, three tables of financial transactions, orders, sales each with a transaction date... Is it better to have a group of slicers that interact on each tables dates or to link all dates to a calendar table and slice only on that date?

I never let end users use the filter, I always create slicers and always drop down

Nyce graphic on that T!

How to select only one option in two different filters? example: In Filttro 1 it has the options (A, B ,C) and in Filttro 2 it has the options (D,E,F). So, how to select only 1 option among all options (A,B,C,D,E,F)?

Q: I have a page, on this page there are 3 bookmarks with buttons to switch the visuals, when I open the slicer panel the views change. I just want the panel to open and close. lol sorry I'm new to BI

Thanks for sharing how the use of drop down and collapsing filter pane effect querying performance

from filter pane (page/report), is there any way to change date filter from dropdown to 'between start date and end date' filter? whereas slicer can. Im still trying to figure out which to use, so far slicer is the better option. but thank you for the video, always helpful. thank you

I think another other point... it's with filter, you can personalize yours slicers... In the example you can use the filter to chose who years can you see in the slicer....

how did you do the apply? slicer are supposedt to be automatic, right?

How can Hiding a Slicer for a value from another slicer?

Does anyone know how the "All Years Selected" at the top of the dashboard was created at 7:04?

Hi Guys! Is it possible to do dependent on each other filters inside the filters pane?

Some really nice tips in here, the Edit Interactions is now my friend. I hadn't spotted that before.

There really needs to be override options on the filter panel. So I can set an all pages filter , but then on an individual page I want to say ‘ignore all page filters’ Or on a specific visual I want to say ‘ignore all page filters’ or ‘ignore this page filters’

Great 👍Adam you can make things very easy to understand

Great info in this video. Thank you very much!

AWESOME video Adam, thanks! 😄

How can I use two slicers for example sales rep and year? So I want to see revenue for an employee but for a particular year. But this report needs to be for an end user.

brilliant video so so helpful thank you!!!

how does a grouped navigation menu ?? to hide/show

Hi Guys. Great video as always. Is there a way to conditional format a card visual based on a categorical column. Ex: Conditional Formatting a Game Score (1-0, 4-5) in a Card depending upon the result (Win, Lose, Draw)

Can we sync filter pane with the slicers?

Dude, this is great. Thank you so much!

exactly what i was looking for! thanks a lot man

Excellent source of knowledge...

Very informative video. Nice one! I wish I can learn how to use that bookmark together with other tools such as slicers.

Nice video you earned your like bro !

I was actually wondering about the difference between slicers and filters last week. Thanks for the breakdown of the two.

I like these recent basic videos with the simple yet powerful content !!

Thank you for this video. I have a question, I hope the Guy in. a Cube can help me or someone in the audience. My Slicer has only 2 options "List" and "Dropdown" I updated to the lastest version of PowerBI , But still I can't see all the options that you have available in this video. Please, could you tell me how can I enable the other options?

Thank you. This was really helpful.

This is some real pro shit!!!! :)

Selection pane - great idea!!!

hi, is it possible yet to get the slicer to auto-select? example, slicer with Week No.s, for it to select todays week or is there a work around this?

you are awesomeeeeee

Great video!!