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.
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.
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.
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!
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.
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 👍
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?
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.
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?
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?
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.
@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.
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?
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.
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?
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.
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?
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.
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.
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.
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
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!!
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.
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)?
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? :)
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
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.
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.
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.
hey, how to create independent rate card.. means when i add filter on one card that should not effect other card...it should only one effect when i select from the Slicer(list/dropdwon)..plz do help
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.
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
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?
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.
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!
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
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
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
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?
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?
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.
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 :)
Q: Hi.... I have a problem..... I am trying to sync slicers from two tables both consisting of month and Year in the same format. But I would like one slicer to filter two different tables. Been trying things that are getting messy and would not be able to even explain what I have done. But essentially I had two slicers (slicer1, Slicer2)each pulling in the year,month from the two different tables. One page has has slicer1 and filters table2. Page two has Slicer2 and table2 but I want Slicer1 to filter Slicer2... hope that makes sense. Table1 and table2 have a relationship between them. Not sure if I am not doing it right. Any help would be appreciated.
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?
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
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.
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??
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.
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!
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?
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.
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?
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.
I don't know how I would live without this channel. You guys' videos rock!
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.
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.
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!
What was the DAX for your #Claim measure? Did you use selectedvalue?
th-cam.com/video/1yv5srlqgmI/w-d-xo.html
SIMPLY AMAZING!!! I was digging it for so many days until I found your video! Thank you !!!!!!!!!!!!!!!!!!!!
Just in time! I was just thinking about this kind of situation and you've just released a video on it! :) Thank you!
Thanks for watching! 👊
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.
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 👍
Awesome. It just help all around!
Patrick, fantastic as always. I had not thought about using the visual level filters in that way. Pure genius.
Have found that a lot of folks don’t know about this. 👊
Patrick, I am going crazy with the filters. I did what u did and still not working :( What could be?
You're awesome! Thank you! I've been struggling with that slicers limitation for year!
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?
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.
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?
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?
U can switch to tile slicers. they rock for this kind of situation!
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.
I love my dynamic slicers.. now I’ll love them even more! great tip :)
Sweet! Thanks for watching! 👊
@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.
Hello sir, what was the measure that you written for #claims ??
th-cam.com/video/1yv5srlqgmI/w-d-xo.html
absolutely great Patrick! , you deserve 5 stars for this trick, what i love about it is living one to many relationship
Thank you! 👊
Awesome stuff; this definitely helped me with making the report flow very well with multiple slicers at play. Thanks very much, sir.
Excellent! 👊
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?
Very neat trick, thanks for sharing!
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.
Bump. Same problem.
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?
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.
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?
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
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?
Thank you for your helpful tutors, I have a questions how do I do Last Decade and Decade over decade in power bi?
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.
Hey Patrick! Do you know of a way to apply this same concept but to filters in the filter pane?
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.
Great tip, Thanks a lot
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.
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
Important: this only works if the filter is on a MEASURE. It doesn't work with column values...
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!!
Are they ever gonna fix it for slicers that are in slider form?
That's been broken since day 1 of measure visual filtering.
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.
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)?
What is the measure #claims ???
th-cam.com/video/1yv5srlqgmI/w-d-xo.html
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? :)
I have been searching for the same!
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
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.
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.
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.
hey, how to create independent rate card.. means when i add filter on one card that should not effect other card...it should only one effect when i select from the Slicer(list/dropdwon)..plz do help
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.
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
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?
I guess it is great idea.. I will try it for sure
Great content guys, thanks for sharing !
Thanks for watching! 👊
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.
Thank you for the help :)
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!
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
How about using Edit Interactions between these two slicers ??
yeah but what is that measure that you used to filter? where does it come from?
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
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
You are great man! Thank you
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?
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?
Did you get the answer I am looking for that
Is it possible to also have a date filter (using a date table) so it only shows the dates with available values?
what we can write in #Claim Measure?
th-cam.com/video/1yv5srlqgmI/w-d-xo.html
Thank you Patrick! I love your contents!
My pleasure!
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.
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 :)
This can be done on a single table report?
Q: Hi.... I have a problem.....
I am trying to sync slicers from two tables both consisting of month and Year in the same format. But I would like one slicer to filter two different tables. Been trying things that are getting messy and would not be able to even explain what I have done. But essentially I had two slicers (slicer1, Slicer2)each pulling in the year,month from the two different tables. One page has has slicer1 and filters table2. Page two has Slicer2 and table2 but I want Slicer1 to filter Slicer2... hope that makes sense. Table1 and table2 have a relationship between them.
Not sure if I am not doing it right. Any help would be appreciated.
What's the issue with bi-directional filter ? Am wondering because i use it a lot on my PBIs
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?
Hi, Is there a way to download demo's PBIX file. Please let me know.
Short and sweet! Thanks. :)
So what could I do for the slicers in excel linked to power pivot?
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
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.
Amazing, no doubt! Thanks for the gemreat content!
Any suggestions how to achieve a similar experience with the filters pane?
Thanks for the great content man
thank you so much. You made my day.
Great solution!!!
This is genius!!! Thank you
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??
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 ?
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.
Exactly looking for this.. thanks man..👏👏👌
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!
Patrick, why when I Use a BarSlicer it doesnt work?
Great! Tell me, what microphone are you using?
Thanks it is very amazing!
Thanks for watching! 👊
I'm pretty sure I just finished telling a client a few weeks ago that this still wasn't possible. DOH.
I also did that.. hehehe
But I send an email talking that a new update is coming to solve this problem, and boom - worked!
@@leonardomauro7894 works everytime
@@richiezubiri3385 hehehe.. 😅
Nice shirt, was a good conference and was nice meeting you guys!
Pleasure meeting you! 👊
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?
Where do I get a PowerBi Texas Tshirt?
I'm laughing at the "I'm sweating" interpretation HAHAHA
As I saw that I started sweating then ... phew..
Hey man, God Bless You!
That's all I want to say.
Thanks!!!
Where did you get that shirt? I want one!
Great trick!!
Thanks! 👊
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.
What is in that measure tho? I don't follow it. #claims measure?
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?