Coming from Tableau, it's shocking to me that it isn't a native feature. Was surprised to see learning how to do it is a 15 minute video instead of just two clicks
Dear Bas, your videos and teaching style is impressive. Love the way you break down things. All the best and wishing you all the success in everything you do.
Bas, I bow to you - you do amazing work and put out even better content. Any chance of you doing problem solving livestreams? showcase your talents in real time?
Great video! I’ve implemented the dynamic dates slicer by assigning min and max transactions dates values in the min and max fields of the visual itself (there is a special setting for it)
Thanks a lot, Bas. Just a small digression on this bi-direction with a 1-to-1 cardinality; would you agree that ideally it should be merged into a single table? I'd like to hear your opinion on this as I try avoiding bi-direction, and almost always have never used a 1-to-1 cardinality in my data model.
Dear Sir, this is amazing, thank you for sharing knowledge. I have an issue with drill through filter, drill through filters cannot select the value in slicer, how do I make slicer value selected when I drill through from another page
Thanks a lot! Is it possible to similarly make the filters in the filter pane smarter so that for every field used as filter only values selected by (compatible with/relavant because of) other already applied filters show up as options ? thank you
Love this. Im working on a way to create Top level slicer to activate different groups of a Slicers with same functionality you showed in this video to show/Hide vs 1+groups. Is there a way to do that?
Hello Bass, first, thanks for the video. I generally like your videos very much, but in this one I did find a flaw with respect to the range slicer. I downloaded the original file to check it out but I got exactly the same behaviour in my own dashboard. It turns out the high slicer value is updated automatically as soon as the user update the company selection. However, the low slicer value doesn't follow suit. in fact, it stayed exactly where it was left for the previous selection. To update its value the user must manually bring the slider to a position inside the range of values, applicable to the new selection, and than take it back all the way down. Then, and only then, the lower slicer value is updated to the correct value. This behaviour may confuse many users! Kindly be aware.
I was creating similar solution and found one bug, when you will select Company A then time range slicer will be adjusted (showing first date in left box and last date in right box for Company A), then when you will change date in left box to another day and then you will change Company A to B, then left box of time range slicer will still kept what you set for Company A, right box will change for last date for Company B), there was no reset function when user changed something in time range slicer. Did you also face this bug ? in 19:28 of this vid there is a momemnt with 3 companies selected and left date box is set to 12/04/2021, please check what will happen if you then will click on Company D, I bet left date box will still keep 12/04/2021
i have two different column for start and end date for filter end date should be greater than start date in the selection , how can i achieve that, please suggest.
Thank you. but how to show only those values in the slicer which have data when the slicer is in sync in other tabs. The other tabs have same slicer but the fact data is coming from different fact tables. Could please help me with this
Thank you for the quality tutorials you make. I have benefited greatly from them. Please I have this question, what do I do when I have Blank in Visual but there is No Blank in that table column?
How would you implement this if the filter is used on different pages and needs a different measure to filter the other slicers? As far as I know you can't apply measure to filter on page so I am quite stuck in this predicament. The customer would like all slicers to sync over the pages but need to use different slicer filters cause the underlying fact table is changing...
Hello, 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)?
Hi Bas, I am not getting the issue you explained @ 8.03 . When Coffee Machine is selected, the Store Amsterdam is not showing in the Store Name slicer. Seems like it working is that it should be or is there something I am missing? I have the latest Nov'21 PBI update. Please note I have not used the custom Hierarchy filter. Kindly advise.
Hi! Thanks for the content. Can you tell me if it is possible to filter multiple values at once? Let's say we have 100 products, but we want to take a closer look at only 10 of them, I have to filter them one by one, is there any possibility to copy the list of products I am interested in (e.g. from Excel) and paste the products in some filter?
Sir, How we can do the function similar to Indirect function in Excel, in power BI. For Ex. I am having a slicer with the name of all Indian states, If I don't select any thing from slicer, then in the table for ROW value , name of state should come and their population will come from measure. If I select any state from slicer , then in the table, respective district list should appear and there population. Please advise how we can do this.
Have been stuck on the last filter type you showed with having a date range only show dates associated with data. I have a report with data up to March of this year, but the export of said data is delayed at least a Month or Two so when I finally update it, I get blank months showing. Note that there are multiple pages on my report with many many Fields so I wouldn't be able to make a slicer filter for all of them, so my thought is to adjust the formula used to generate the dates in a table. Could you possibly make a video showing what a date formula would look like that continued to add dates via a year/month when new data was imported, but not include blank months when data is delayed?
Scenario 1.calendar table 2. Table1 created in m query using some.condition 3. Need to create table2 using dax where date is selected in slicer should produce a table with records from selected date till the max date Eg..List of dates for an year If I select 09/14/2025 it should give table result from 14 sep 2025to 31st dec 2025 and so on I am.facing problem where I am storing the selectedvalue date in a variable it diaplays correctly on the card but when I try to create table using dax it passes it as null Filter condition is loadstartdate>=selectedvalue (date) Note: Table 2 is exact copy of table1 just have filtered rows based on selecteddate till max date
Why don’t you keep relationships unidirectional and add the measure [Total Sales] to each slicer filter (is not blank). That keeps your model without bidirectional relationships.
Nice video as usual! Personally I think this should be a native feature that could be configured without a work around.
Coming from Tableau, it's shocking to me that it isn't a native feature. Was surprised to see learning how to do it is a 15 minute video instead of just two clicks
Another level of combo slicer and visual filter. Great. thanks.
Thanks a lot, Bas, This video was literally a savior for me.
Dear Bas, your videos and teaching style is impressive. Love the way you break down things. All the best and wishing you all the success in everything you do.
Thank you very much Bhanuka!!! 🙏👍 all the best to you too!
Bas, I bow to you - you do amazing work and put out even better content. Any chance of you doing problem solving livestreams? showcase your talents in real time?
Great video!
I’ve implemented the dynamic dates slicer by assigning min and max transactions dates values in the min and max fields of the visual itself (there is a special setting for it)
You are awesome. Clear and logical explanations. Great for filling in the gaps between DNA enterprise and sqlbi.
Thanks a lot, Bas. Just a small digression on this bi-direction with a 1-to-1 cardinality; would you agree that ideally it should be merged into a single table? I'd like to hear your opinion on this as I try avoiding bi-direction, and almost always have never used a 1-to-1 cardinality in my data model.
great tutorial. thank you!
Nice video and very useful. please, Please use the full screen of Power Bi. That would be BETTER Viewer Experience.
Thanks for the feedback Vipin
Dear Sir, this is amazing, thank you for sharing knowledge. I have an issue with drill through filter, drill through filters cannot select the value in slicer, how do I make slicer value selected when I drill through from another page
Великолепно! Ты красавчик! Сильно помог в части связи фильтров!
большое спасибо за просмотр
Thanks a lot! Is it possible to similarly make the filters in the filter pane smarter so that for every field used as filter only values selected by (compatible with/relavant because of) other already applied filters show up as options ? thank you
Came across your channel recently. Fantastic!
such a great content. Amazing the simplicity you do it all. Thank you so much Bas
Hi Bas, Is there anyway we can use measure value on x axis?
It's fascinating. Thank you for this wonderful video 💕
glad you enjoyed it - thx Akshay!
Love this. Im working on a way to create Top level slicer to activate different groups of a Slicers with same functionality you showed in this video to show/Hide vs 1+groups. Is there a way to do that?
Hello Bass, first, thanks for the video. I generally like your videos very much, but in this one I did find a flaw with respect to the range slicer. I downloaded the original file to check it out but I got exactly the same behaviour in my own dashboard. It turns out the high slicer value is updated automatically as soon as the user update the company selection. However, the low slicer value doesn't follow suit. in fact, it stayed exactly where it was left for the previous selection. To update its value the user must manually bring the slider to a position inside the range of values, applicable to the new selection, and than take it back all the way down. Then, and only then, the lower slicer value is updated to the correct value. This behaviour may confuse many users!
Kindly be aware.
Great video Bas - can I re-order chiclet slicers? I have years ascending but I need them descending, can this be done???
I was creating similar solution and found one bug, when you will select Company A then time range slicer will be adjusted (showing first date in left box and last date in right box for Company A), then when you will change date in left box to another day and then you will change Company A to B, then left box of time range slicer will still kept what you set for Company A, right box will change for last date for Company B), there was no reset function when user changed something in time range slicer. Did you also face this bug ?
in 19:28 of this vid there is a momemnt with 3 companies selected and left date box is set to 12/04/2021, please check what will happen if you then will click on Company D, I bet left date box will still keep 12/04/2021
i have two different column for start and end date for filter end date should be greater than start date in the selection , how can i achieve that, please suggest.
Thank you. but how to show only those values in the slicer which have data when the slicer is in sync in other tabs. The other tabs have same slicer but the fact data is coming from different fact tables. Could please help me with this
Another great one! Thanks so much, Bas!
:):) glad you like it Chris!
Awesome as always. Thank you.
Thank you for the quality tutorials you make.
I have benefited greatly from them.
Please I have this question, what do I do when I have Blank in Visual but there is No Blank in that table column?
Awesome video! Thanks for this content 🤩
Thank u so so so much you solved a error which killing me from last 2 weeks. I'm now ur subscriber. 🙏🙏🙏🙏🙏
thank you so much for the sub! - happy to hear the video helped you
How would you implement this if the filter is used on different pages and needs a different measure to filter the other slicers? As far as I know you can't apply measure to filter on page so I am quite stuck in this predicament. The customer would like all slicers to sync over the pages but need to use different slicer filters cause the underlying fact table is changing...
Hello, 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)?
Very useful video👍Thanks🙂
Hi Bas, I am not getting the issue you explained @ 8.03 . When Coffee Machine is selected, the Store Amsterdam is not showing in the Store Name slicer. Seems like it working is that it should be or is there something I am missing? I have the latest Nov'21 PBI update. Please note I have not used the custom Hierarchy filter. Kindly advise.
Hi! Thanks for the content.
Can you tell me if it is possible to filter multiple values at once?
Let's say we have 100 products, but we want to take a closer look at only 10 of them, I have to filter them one by one, is there any possibility to copy the list of products I am interested in (e.g. from Excel) and paste the products in some filter?
Excellent video
Great Video
thank you Shivam!! 😀😊
Sir, How we can do the function similar to Indirect function in Excel, in power BI. For Ex. I am having a slicer with the name of all Indian states, If I don't select any thing from slicer, then in the table for ROW value , name of state should come and their population will come from measure. If I select any state from slicer , then in the table, respective district list should appear and there population.
Please advise how we can do this.
Have been stuck on the last filter type you showed with having a date range only show dates associated with data. I have a report with data up to March of this year, but the export of said data is delayed at least a Month or Two so when I finally update it, I get blank months showing. Note that there are multiple pages on my report with many many Fields so I wouldn't be able to make a slicer filter for all of them, so my thought is to adjust the formula used to generate the dates in a table. Could you possibly make a video showing what a date formula would look like that continued to add dates via a year/month when new data was imported, but not include blank months when data is delayed?
so did you make it work?
awesome vid...thanks
Thks Bas , 👍
Awesome 👏
Thx Erick!!! 👊😎
Superlike to this video
Scenario
1.calendar table
2. Table1 created in m query using some.condition
3. Need to create table2 using dax where date is selected in slicer should produce a table with records from selected date till the max date
Eg..List of dates for an year
If I select 09/14/2025 it should give table result from 14 sep 2025to 31st dec 2025 and so on
I am.facing problem where I am storing the selectedvalue date in a variable it diaplays correctly on the card but when I try to create table using dax it passes it as null
Filter condition is loadstartdate>=selectedvalue (date)
Note: Table 2 is exact copy of table1 just have filtered rows based on selecteddate till max date
oh my god!! perfect
Interesting!
Why don’t you keep relationships unidirectional and add the measure [Total Sales] to each slicer filter (is not blank). That keeps your model without bidirectional relationships.
I do 😉 just watch a bit further