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.
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
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.
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
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 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?
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
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)?
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.
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?
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?
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?
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
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!
Another level of combo slicer and visual filter. Great. thanks.
Thanks a lot, Bas, This video was literally a savior for me.
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?
Великолепно! Ты красавчик! Сильно помог в части связи фильтров!
большое спасибо за просмотр
You are awesome. Clear and logical explanations. Great for filling in the gaps between DNA enterprise and sqlbi.
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)
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
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
such a great content. Amazing the simplicity you do it all. Thank you so much Bas
Came across your channel recently. Fantastic!
It's fascinating. Thank you for this wonderful video 💕
glad you enjoyed it - thx Akshay!
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.
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
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.
Awesome video! Thanks for this content 🤩
Very useful video👍Thanks🙂
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
Awesome as always. Thank you.
Another great one! Thanks so much, Bas!
:):) glad you like it Chris!
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.
Hi Bas, Is there anyway we can use measure value on x axis?
Excellent video
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?
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
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...
awesome vid...thanks
Great Video
thank you Shivam!! 😀😊
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)?
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.
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?
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.
Thks Bas , 👍
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?
Great video Bas - can I re-order chiclet slicers? I have years ascending but I need them descending, can this be done???
Awesome 👏
Thx Erick!!! 👊😎
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?
Superlike to this video
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