Going CRAZY with Power BI slicers not filtering other slicers????

[@gintomino4136]

I would like to thank you for sharing this with us Power BI users. I have this report that I’m developing and it’s driving me nuts due to millions of records. I am glad I found your video to solve my problem with slicers. Instead of putting everything in one fact table to achieve the same result, I was looking for ways to modify the relationship but failed. This is a neat trick. You saved me a lot of time! Thank you again! God bless you.

[@morganmcgary921]

I don't know how I would live without this channel. You guys' videos rock!

[@ajaaskelainen]

Just in time! I was just thinking about this kind of situation and you've just released a video on it! :) Thank you!

[@GuyInACube]

Thanks for watching! 👊

[@miguelserrano4432]

Oh man. Thank you so much! I have two fact tables that need simultaneous slicers and while connected I couldn't get slicers to filter each other! Life saver.

[@budgetdust5631]

Patrick, fantastic as always. I had not thought about using the visual level filters in that way. Pure genius.

[@GuyInACube]

Have found that a lot of folks don’t know about this. 👊

[@koshelevkl]

You're awesome! Thank you! I've been struggling with that slicers limitation for year!

[@SidneySantana]

SIMPLY AMAZING!!! I was digging it for so many days until I found your video! Thank you !!!!!!!!!!!!!!!!!!!!

[@staceydunning3008]

Thank you. I didn't think to do that before. I had been using the Edit interactions feature instead. I notice both methods still leave the artifact of whatever slicer you had selected below, so if you'd had a different airline up and made a selection, then when you switched to one that didn't have any claims greater than 0 for that selection, it still shows because it's selected. I wish there was a behavior that stopped that or cleared selections.

[@ShabnamKhan-vk7fj]

This is great, thanks for bringing this up, I have read many articles and seen many lectures but it doesn't talk about these kinds small tricks that are super helpful. And often time it's hard to even look for it on the web as I don't know what to search for.

[@adriansanchezr.8508]

I have been doing this without knowing if it was best practice. In order to limit a slicer based on a very large list (+1000 elements) in my dimensions table, when there's is maybe 700 of these elements in the facts table and want to hide those 300 empty elements on the slicer. It works beautifully! Thanks Patrick for showing us the way 👍

[@GuyInACube]

Awesome. It just help all around!

[@merrycain]

Coming from using Tableau where you only click a button make the it show relevant values only I've been struggling with how to achieve this in PBI. Thank you for this video! Worked like a CHARM!! Got a subscribe here!

[@lisagalley]

I think this solves a long standing filter problem I’ve had with a map where a “state” filter should filter a “city” filter and only show the cities corresponding to that state. Can’t wait to try this out.

[@mwaltercpa]

I love my dynamic slicers.. now I’ll love them even more! great tip :)

[@GuyInACube]

Sweet! Thanks for watching! 👊

[@DIGITAL_COOKING]

absolutely great Patrick! , you deserve 5 stars for this trick, what i love about it is living one to many relationship

[@GuyInACube]

Thank you! 👊

[@murdockjp]

Awesome stuff; this definitely helped me with making the report flow very well with multiple slicers at play. Thanks very much, sir.

[@GuyInACube]

Excellent! 👊

[@aleena1549]

This is amazing. I am new to this but from what i understand on the internet, directional crossfiltering can be a huge risk and people are using that just to have a dimension filtered based on selection of another dimension. But this can be so easily done with method you shown. Why are people not looking at it then i wonder.

[@christinawade4508]

What was the DAX for your #Claim measure? Did you use selectedvalue?

[@fitzerpn]

kzbin.info/www/bejne/Z6rZZqaoodaao6s

[@Valentina-lg9ln]

Patrick, I am going crazy with the filters. I did what u did and still not working :( What could be?

[@rajnichawla2548]

Hi, after a particular selection, if we change the Airline, the Claims list refreshes per the Airline but also shows the previously selected value (from the previously selected Airline). May be this is the default behavior of the slicers. But how do we avoid this?

[@ForgottenBeastMetal]

Pat, I was kinda rolling my eyes for a second I thought you were leading on to edit interactions. Then BAM! Great use of the visual filter

[@arklur3193]

Thanks for making the video, I was glad when they finally made this possible! One thing though what I really mis is that a "deep dive" video about what can go wrong with using bidirectional relationships, because usually I only read/hear that "just don't do it!", but no "real life scenarios" (the only thing I could think of is date related stuff which can easily break with bidirectional relationships). Any plan to make a video on that? Invite one of the 2 DAX gods maybe? :)

[@th1493]

I have been searching for the same!

[@luisalejandrorodriguezcamp9516]

Yes I feel the same. There is too much fear spreading on this topic... lots of people saying "don't use them unless you know what you are doing" but few explanations on it. And one of these few explanations was provided by Patrick in this same channel, maybe it does not go into deep, but is an initial approach

[@mateuszhanczuk2043]

Lets say that we have table for accounts and another one for regions. Then we have 2 fact tables. One for actuals and one for forecast. Both fact tables are using accounts and regions. It is fine to create that model with single direction relationships. Dictionary tables are filtering fact tables. With both direction selected these will go into a loop and Power BI will be confused what is filtering what. Selection on region will filter accounts and accounts will filter back regions. If there are different region combinations within 2 fact tables you are doomed.

[@mcnater]

I 100% agree on this. I've worked with Qlikview for a decade and bi-directional is the Default way. I too wish they'd show more WHY they think it's such a bad idea in cases to not use bi-directional.

[@mateuszhanczuk2043]

If I remember correctly Qlik handles bi directional collisions by creating virtual table with synthetic keys automatically inside data model. Power BI gives more control over shape of the model so it does not do that by itself.

[@sixtyfiveroses2968]

Very neat trick, thanks for sharing!

[@VarshaChirayath]

Hey this is great content and thank you for all the information you provided through your channel. With regard to his video, I understand that you are filtering out claims equals zero. But what if say instead of claims, it's another categorical filter that has to show only relevant values based on the first filter? Tableau has a feature called "show relevant values" . I'm looking for something similar. Please respond.

[@samf5845]

Hey Patrick, first time commenter and new-ish to Power BI! Thank you for covering this topic!! I was hoping you would have tips on many-to-many schemas - my first work project is a pretty hot dashboard now, and I'd be thrilled to talk about this concept in my report's environment with you if you are willing! Load time is surprisingly quick, but I had to come up with some pretty intensive measures, and I wonder if there's an easier way.

[@madhurisriram1087]

Amazing tip. What if we have multiple fact tables with few common columns and all of them share same dimension tables. When I use a measure as a visual level filter from first fact table, then slicers are not in sync for the second fact table scenarios. Could you please help Patrick?

[@hermesjrd]

Great tip, Thanks a lot

[@WisdomSeeker2447]

I guess it is great idea.. I will try it for sure

[@owoled282]

Great content guys, thanks for sharing !

[@GuyInACube]

Thanks for watching! 👊

[@huludShai]

Thank you Patrick! I love your contents!

[@GuyInACube]

My pleasure!

[@fabiovanroon1524]

Thank you for all the great videos! So for slicers to properly work, you need a unique, one way relationship between tables? Let's say you had an address table, and then a table with orders that contained cities and states...you cannot relate the two fields...you need somehow to come up with a composite field/key?

[@steveetmarie8341]

Important: this only works if the filter is on a MEASURE. It doesn't work with column values...

[@Evan-mh7it]

Nice shirt, was a good conference and was nice meeting you guys!

[@GuyInACube]

Pleasure meeting you! 👊

[@hotboyphil]

i like this idea, any way to force a slicer to select the first option? i used to used the force selection option before but they took it off the slicer, if you can think of a work around?

[@rcb3921]

I'm pretty sure I just finished telling a client a few weeks ago that this still wasn't possible. DOH.

[@leonardomauro7894]

I also did that.. hehehe But I send an email talking that a new update is coming to solve this problem, and boom - worked!

[@richiezubiri3385]

@@leonardomauro7894 works everytime

[@leonardomauro7894]

@@richiezubiri3385 hehehe.. 😅

[@axedice]

This works very well, so thanks for the info Patrick. But I have another question. In a very similar setup my slicers filter each other, but my drilldowns in graphs do not filter the slicers. Is that also possible to achieve?

[@AliVaseghnia]

Short and sweet! Thanks. :)

[@vikkijogalvin]

This is genius!!! Thank you

[@giorgosi.fovakis8810]

You are great man! Thank you

[@DroneEyes]

Hi Patrick very clever solution!!! I noticed that your filter allows users to type start typing in order to narrow down the results ... I used the same slicer before but I couldn't find the setting to turn that on. Can you please tell us how you did that? Thanks

[@kunal0509]

Thank you for the help :)

[@aakashbang4911]

Hi Patrick. Love your videos. I wonder if there's a way to apply relative date filter (using the filters pane) to a date slicer set to "between". The filter on slicer approach doesn't work with the date filter. The use case is the user wants to default the report to the last 14 days while still having the ability to select a custom date range using the date slicer. Would love to know your thoughts and ways to deal with this.

[@Breathtaker]

Bump. Same problem.

[@economyonroll9274]

When you make selection in the second slicer, and change the selection in first slicer, it shows the previously selected one. Seems power bi refresh once it is selected

[@karthikj9326]

Hello sir, what was the measure that you written for #claims ??

[@fitzerpn]

kzbin.info/www/bejne/Z6rZZqaoodaao6s

[@stephenclarke7351]

Thanks for the great content man

[@JKeikoChung]

Thank you for your videos! A very clever but easy way to achieve the result. I've got a question... I need a way to filter for an exact match. For instance, I have a part called AB, but when I enter AB in slicer, it pulls 100's of parts containing AB. How do I do that? Thank you in advance.

[@muraliprasath99]

thank you so much. You made my day.

[@lloyd_talks]

Great solution!!!

[@agnesmarco]

Thanx but what if the user selected “Baggage Claim” within Airlingus and afterwards selects another airline. Then all the visuals will show nothing i guess. How to overrule this by default? Tableau functionates more Logic in this situation i think.

[@sherifffruitfly]

Are they ever gonna fix it for slicers that are in slider form? That's been broken since day 1 of measure visual filtering.

[@daaxx1]

Amazing, no doubt! Thanks for the gemreat content! Any suggestions how to achieve a similar experience with the filters pane?

[@JhowCanedo]

I'm laughing at the "I'm sweating" interpretation HAHAHA

[@joelcentofanti7077]

As I saw that I started sweating then ... phew..

[@gopigopichand4379]

Exactly looking for this.. thanks man..👏👏👌

[@beknazarosmonov8567]

Thanks it is very amazing!

[@GuyInACube]

Thanks for watching! 👊

[@viktorshehi2136]

Hi Patrick, how about drill through filters applied to the report where you drilled and the actual filters of that report? I want to be able to use the report filters (ex the store and date filter) and when I drill to that report from another one I want the filters coming from the other report to "overwrite" the previous filters. To sum up, I want to reset all filters and apply filters of drill through coming from the other report. How to do that?

[@davidmendez3997]

How do you do the same trick but on the filter pane? Meaning, how do you cascade your selections on the filter pane based on slicer selection?

[@HT_Peace7]

Thank you for your helpful tutors, I have a questions how do I do Last Decade and Decade over decade in power bi?

[@shristiprakash1307]

@Guyinacube Thank you for the explanation. But what if I have not only one measure like claim here but multiple measures, for example: I may have claims, as well as disbursed amount and more measures showing in the same matrix. then how should I filter the claim site name in the slicer by airlines name.

[@tomasantunes891]

But what if the Claim Site Slicer is "Single Select"...? It will always have the option selected before changing the Airline again, and wich will have (Blank) values... is it possible to solve this?

[@aicancino]

Thanks!!!

[@daphnerosario]

Thanks Patrick! Love your energy. I created a query and brought it into power Bi but it doesn't move with the date slicer. Any thoughts? Thanks in advance :)

[@analisecritica8722]

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

[@NaraMeerammaTrust]

Nice Video. How about using the cross filter with DAX as a calculated column and start using that as a filter? Let me know if it doesn't achieve what we are looking for here. Will be waiting for your reply. Thank you

[@paraspatel4879]

Hi Venkatesh, Since you mentioned DAX Measure I hope you would be able to solve my issue. community.powerbi.com/t5/Desktop/Measure-DAX-Calculate-percentage-based-on-2-column-and-Dates/td-p/939589 This is a link to the Power BI Community where I posted my question. Looking forward to hear back from you.

[@pratikfutane8131]

Great trick!!

[@GuyInACube]

Thanks! 👊

[@dariuszspiewak5624]

Patrick, I've found that the conditions that we can use on the Filter Pane can't use a measure that returns a boolean. These measures have to return a number. Any idea why? Let's take your example. If we created a helper measure that would return True if there were any claims for the selected claim site and False otherwise, we could not use this intuitive measure in the Filter Pane. We would have to turn True into 1 and False to 0 to be able to use it in there... I don't like it to be honest because it's not intuitive.

[@maheshg4136]

what we can write in #Claim Measure?

[@fitzerpn]

kzbin.info/www/bejne/Z6rZZqaoodaao6s

[@kalpeshmalpani3798]

How about using Edit Interactions between these two slicers ??

[@AMITKUMARTRIPATHYtheboss]

Hi Patrick, Amazing trick! One question though, if we keep the slicer filter greater than amount 0, it stops showing the blank values in the slicer even when none of the slicers were selected, Do you have any suggestion for this problem??

[@cikguismat2708]

I have a question. Let say I have a list under "Claim Site" but with different category of claim. I make 3 slicers, each for different category (filtered by category using the filter panel). How do I stick the list of "Claim Site" for each slicer? I have problems that whenever I click an option in a slicer, the list (of claims) on the other two disappears.

[@juanantoniomontes]

Hello Patrick Thank you very much for the video. But I have a new challenge, how can I filter a slicer with the selection of a bar from a chart? For example: I have a slicer with products and I have a bar chart with the quantities of products sold per store. If I choose a store, I would like the slicer to be reduced to only the products that store sold. All the data comes from the same table. Is this possible?

[@lucasbarroos]

Hi Patrick, any idea of how can I do the same thing with Dates? I have a sceario where I have the "Fiscal Year" slicer and a "Date" slicer, but Fiscal Year is not filtering the Date Slicer. I tried your approach, but I got lost when using dates.

[@tairusadiq3527]

Is it possible to also have a date filter (using a date table) so it only shows the dates with available values?

[@harshtrivedi700]

Nice, but you dont really show what the #Claims formula look like, some DAX functions will not work with this approach

[@fitzerpn]

kzbin.info/www/bejne/Z6rZZqaoodaao6s

[@Bac2277]

However, in my case, I want to filter a slicer with other slicer but both the slicers are the bridge tables in my data model. How to implement for my case?

[@marlenawolska7519]

Hello Patrick . I have 2 issues with slicer. 1. I'm using a chicklet slicer for 3 nations and I would like to rename the select all button. 2. I would like to unable one of the visuals on select all option but keep when selecting the other. Please help

[@YoctoGamer]

yeah but what is that measure that you used to filter? where does it come from?

[@kvillamil1]

Hey Patrick! Do you know of a way to apply this same concept but to filters in the filter pane?

[@julianocorma]

Hi guys I only see the options: Contains Does not contain Starts with Does not start with Is Is not Is blank Is not blank But I don't have the option: Is greater than What should I do?

[@ernestogarcia9489]

This can be done on a single table report?

[@smellypantss]

Hey man, God Bless You! That's all I want to say.

[@jackhillyer3397]

I have a question for you Patrick about something similar. I dont want to filter a slicer by another slicer. I want my visual interaction to filter a slicer. currently a visual interaction filters all of the other tables but does not filter my slicer. As far as I know, it doesn't work that way but I don't understand why. in fact, in visual interactions, when i edit them the slicer shows up with a filter or dont filter Icon. why would there be an icon for filtering the slicer if it doesn't work? Is there a reason you can filter other visuals through visual interactions but cannot filter a slicer through visual interactions?

[@saikumarp-s2t]

I have an issue if you came across it please let me know. Selecting and deselecting all option on the filter it displays data why it shouldn't display when deselecting all option

[@NadsRocker]

What's the issue with bi-directional filter ? Am wondering because i use it a lot on my PBIs

[@tracykirkman5038]

Hi Patrick, So that's cool, but what do you do with a month slicer? I have a month order table with months Jan - Dec, but at the moment, my visualisations have data for only two months - July & Aug. My slicer is a dropdown, so I don't want my users to see all the months where there is no data. I tried your adding to the visual filter, but it doesn't change anything on the slicer.

[@carlospelay9642]

Hey this is great but there seems to be an edge case where this doesn't work? If I format a Slicer as a slider ("Between") the min and max values are for the whole data set and don't reflect changes in other sliders. Any suggestions? Thanks!!

[@mardithpascua8112]

Hi, I am new to PowerBI - I'm wondering why my pages in may Dashboard in PowerBI online is not adjusting when I select values from a filter located in the First page. In my desktop - I already configured the Sync Slicers.

Great! Tell me, what microphone are you using?

[@salosteysv]

Wow! Super :)

[@davidwilliams6928]

Awesome!

[@GuyInACube]

Thank you! 👊

[@saradachoudhury8732]

Hi, I have one similar kind of requirement that the first slicer will filter only the items of second slicers. And I am able to do it. But while filtering on second slicer "select All" filtering option is not working. Could you please suggest , how to achieve this functionality.

[@tw5335]

Somewhat related question: How do I get a report level filter to apply to slicers?

[@bishastra]

This is great.....but what if we have negative values in claims.

[@arklur3193]

Everything you need to know: www.sqlbi.com/articles/syncing-slicers-in-power-bi/

[@ncbshiva]

Then you can filter where claims is not 0

[@dudeoden]

Filter condition - "is not blank" should be helpful

[@DookyButter]

Where did you get that shirt? I want one!

[@violinasetiawan7647]

Hi, I have a question about this. I have some slicers that used for each visualization in one page. I want to exclude some items in every slicer. I don't understand why it doesn't work for some slicers, but it works for other slicers in my page. The problem is, when I exclude the items in those slicers and then I move to the other bookmarks, then I came back and the slicers become default again (back to normal). Can you help me?

[@abdulhannanijaz4036]

In this case when child slicer is selected it is not unselected automatically and keeps on dragging with other options. How can we fix that ?

[@salehmuhammad6811]

👍great pattrick

[@JenMayB]

Q: my drill through isn’t working with my slicers. My slicers are synced! So the drill through set one value, and then if they go to select another value with the slicer from another page and return to the chart, it is blank because the previous filter from the drill through still applied. help!

[@rebecamontes8364]

Hi, thanks for the video! I still have a problem with my slicers though. Im using the "between" slicers and all of my tables and visuals changes correctly when I choose the ranges i want. However, what i want to do now is the opposite of that. I want to be able to perform changes directly on my visuals and have them reflected on the slicers. But whenever I change my visuals, the slicers doesn't change at all. How can i fix that? Thank you!

[@bitips]

What is the measure #claims ???

[@fitzerpn]

kzbin.info/www/bejne/Z6rZZqaoodaao6s

[@danielalbers4275]

Hi, is it possible that this kind of filtering of the slicers is not working anymore? I used it before but now if I try to setup a slicer (vertical list or drop down) the items are not filtered by the measure (e.g. Value >0). Any help is appreciated. BR Daniel

[@biolaobiwole4095]

Awesome!!!