Power BI slicers vs the filter pane (2021)

[@alt-enter237]

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!

[@kevinmann1598]

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

[@PowerBITrainer]

Hey! Kevin any idea how can i add the same in my report?

[@thepurpleenigma]

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.

[@deanrobinson8983]

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.

[@dms9822]

One way around this is to create a paginated report export where the slicer values can be passed as parameter values. It is also useful when the row count is too large for excel export. Paginated reports are also exported as a pdf or PowerPoint.

[@jaapolsthoorn796]

This has been fixed, the selected slicers are still selected in the exported PDF.

[@kevinmann1598]

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.

[@davida99]

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

[@timtruax3093]

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

[@ilhamayusuf]

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

[@Baldur1005]

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.

[@Henrik.Vestergaard]

Spot on, totally ageree. Sorry to say though, cause filter pane has many pros: easy to add new fields without messing with the layout, gray (cofigurable) background when something is selected . But filter by measure is a BIG miss, having large DIM tables

[@JOSEN-xj5kw]

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.

[@jandreonipretel]

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

[@raz8657]

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

[@peterthompson9412]

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?

[@mpikers]

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

[@radekou]

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.

[@richardcroft3676]

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’

[@ramanujamamoorbabuji146]

I liked the concept of APPLY option

[@graemegourlay2850]

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

[@newtonpritchett9887]

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?

[@dmiradakis]

AWESOME video Adam, thanks! 😄

[@SneedTechIndustries-gf5hn]

So... slicers are individual filters and filters are report-wide filters?

[@maseg46]

exactly what i was looking for! thanks a lot man

[@analisecritica8722]

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

[@joseluisbeltramone599]

Great info in this video. Thank you very much!

[@jlmacalisang]

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

[@Korrinas.Lucario]

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

[@anastasiiaillienko4750]

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

[@alvarobadilla4733]

Nice video you earned your like bro !

[@rajeshkumarpathak4542]

Excellent source of knowledge...

[@tobiasboodh5759]

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!

[@christimbers2006]

I found this little one the other day that enabled me to deliver exactly this scenario... kzbin.info/www/bejne/mWnFYZeMZ7RjgNk

[@mohammadharoon9969]

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

[@Sour_Patch_813]

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

[@rdub9001]

Dude, this is great. Thank you so much!

[@KaterynaYakubovska]

Selection pane - great idea!!!

[@liliancruz5276]

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?

[@DuncanFairweather]

It depends on the datatype of the column you are slicing.

[@mime4331]

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

[@AmritaOSullivan]

brilliant video so so helpful thank you!!!

[@kegomoditswerammutla3447]

Thank you. This was really helpful.

[@KO2840]

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.

[@salehmuhammad6811]

Great 👍Adam you can make things very easy to understand

[@emmanuelajoma1528]

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

[@rangatink2264]

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)

[@gustavo3851]

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

[@koutlaw30]

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

[@islamabdel-ghany2564]

Can we sync filter pane with the slicers?

[@LeonaAmanu]

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

[@shanabenjamin8945]

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

[@Sevententh]

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?

[@arya4it]

There is a work around for this. Create a calculated column which will define week as Latest Week E.g. Week 1 Week 1 Week 2 Week 2 Week 3. Latest Week Now use this new column in slicer and in that select Latest Week Since the slicer shows the default selection which is in this case Latest Week which can represents any week. Hope this helps.

[@Sevententh]

@@arya4it Thanks for the tip. For anyone else thats interested, I have an autoCalendar with an additional field with "Relative Week", IF( WEEKNUM( [Date], 21) = WEEKNUM( TODAY(), 21), "Current Week", YEAR ( [Date] ) & "-" & FORMAT(WEEKNUM([date], 21),"00") ) In my Slicer this shows as: 2021-01, 2021-02, 2021-03, Current Week (Limited to 4 weeks) Select, "Current Week" as the selected slicer and it will always be selected. When we move into future weeks, "Current Week" will still be selected but the weeks will move forward +1, e.g. 2021-02, 2021-03, 2021-04, Current Week

[@shanabenjamin8945]

Nyce graphic on that T!

[@joaquinmaverick82]

Great video!!

[@harryflashman4542]

The best thing about IT is the people.

[@amaramara4683]

excellent

[@nathanymiguel]

you are awesomeeeeee

[@personalsigh]

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

[@mcnater]

Great in theory until you have 10 plus things you want to slice 😂

[@personalsigh]

@@mcnater I've got one report with about 20 and just built a slicer pane to open and close as needed

[@mcnater]

@@personalsigh While nice...that just IMO creates more maintenance and is extra work. I just wish the Filter pane worked better

[@personalsigh]

@@mcnater extra work for me. But less work for the end user and that's what I care about

[@mcnater]

ya...if reports are static I'd agree...but things change too much at my place and long term it's not that viable.

[@harvey2242]

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