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!

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

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

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

AWESOME video Adam, thanks! 😄

Thank you. This was really helpful.

exactly what i was looking for! thanks a lot man

brilliant video so so helpful thank you!!!

Great info in this video. Thank you very much!

Dude, this is great. Thank you so much!

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

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

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

Excellent source of knowledge...

I liked the concept of APPLY option

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 !

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.

Selection pane - great idea!!!

Great video!!

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

Great 👍Adam you can make things very easy to understand

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.

excellent

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.

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?

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.

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)

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

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

you are awesomeeeeee

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’

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.

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

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?

Nyce graphic on that T!

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

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

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

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

Can we sync filter pane with the slicers?

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.

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

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)?

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?

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!

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?

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

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

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

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

The best thing about IT is the people.

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