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

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

exactly what i was looking for! thanks a lot man

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.

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

@ankitkukreja592

3 жыл бұрын

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

AWESOME video Adam, thanks! 😄

Thank you. This was really helpful.

Great info in this video. Thank you very much!

Dude, this is great. Thank you so much!

brilliant video so so helpful thank you!!!

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

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

Nice video you earned your like bro !

Excellent source of knowledge...

Selection pane - great idea!!!

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

Great video!!

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.

Great 👍Adam you can make things very easy to understand

I liked the concept of APPLY option

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.

excellent

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)

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.

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.

@dms9822

3 жыл бұрын

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

2 жыл бұрын

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

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

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

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

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

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!

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

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

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

3 жыл бұрын

I found this little one the other day that enabled me to deliver exactly this scenario... kzread.info/dash/bejne/lWyWksaPYrKWeto.html

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.

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

you are awesomeeeeee

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.

@Henrik.Vestergaard

2 жыл бұрын

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

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

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

2 жыл бұрын

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

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

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

3 жыл бұрын

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

3 жыл бұрын

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

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

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

@mcnater

3 жыл бұрын

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

@personalsigh

3 жыл бұрын

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

@mcnater

3 жыл бұрын

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

@personalsigh

3 жыл бұрын

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

@mcnater

3 жыл бұрын

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