Mr. Ferrari, thank you sir. I wish I had found this video 40 minutes ago but very glad nonetheless. So clean and simple! Tried other methods/videos to no avail.
Thank you for providing optimisation tips. First thing came to my mind when I saw sync slicers title is that the feature available to sync slicers across multiple report pages. Yes this is also syncing slicers data with user selection 👍👍
I bought your 2 books about DAX with Power BI, but these video are complementary and very helpfull! thanks again, great to have you in the BI community :) you the best Alberto!!!!
I would have been happy to get this video as a birthday present. Wow. Maybe you could include this EXTREMELY valuable technique somewhere amongst your DAX patterns, because it's such a common problem.
The patterns we published are about DAX, this is a Power BI technique. Even though Power BI is the main product using DAX these days, it is not the only one!
I thought you we're reposting videos as every other RU-vid channel. Then I remembered you only post top quality stuff! I am using measures in filters to find the ids responsible for blank rows in my model. Very useful indeed!
Amazing content. I have a doubt here. What if select a color and then try to change the Name. What will happen to the selected color value? Say the present name does not purchase that particular color. Thank you!
Hai Alberto! Thank you for the video. I was wondering if i have a week slicer. We update data by daily basis. When we update the file and refresh in the web.. the slicer is not picking the update week. Is there any video from SQL BI or anywhere i can look for this solution? Thank you in advance.
Thank you Alberto! Do you know if there is any specific reason for why Booleans don't work in the visual level filters? Or is it just not implemented yet by Microsoft for no obvious reason?
Thank you for this and other great videos. I have a question. What is Slicers = Filter({1}, False)? I use EmptyTable = just to create an empty table. Thank you in advance
Alberto, thanks for this explanation. Is there a way to do the same type of slicer filtering but in Excel (not Power BI)? [I had a chance to meet you last year at Kansas City PASSSQL conference].
Thanks for the video. Could you say in which situations it is proper to use bi directional filters?? Please put one similar but to filter tooltips. Im trying to filter one table (Calendar) that works as a tooltip through another fact table (Sales). The only way that I have found to do it until now is by a bi directional filter from one table that connects both. Thanks
Where you can use a measure filter, it's safer. Bidirectional filters should be enabled just in measures that really need it, and enabled in the model in particular cases (dynamic security patterns, many-to-many relationships). See this article for more details: www.sqlbi.com/articles/relationships-in-power-bi-and-tabular-models/
Great videos, both this and the previous one, I just have one question. In the case of a Filter in the Filter Panel, this solution is possible or I'll be forced to use bidirectional relationships? In my case, I have RLS by brand, on a multi-brand solution, so a brand should only see the products that belong to them. If I don't use bidirectional relationships between the Sales and product tables, the Product filter in the Filter Panel will show all the products from all brands instead of showing only the products with sales. Hope I explain myself clearly, and thanks for all the videos you've made. Best regards, Mijalis
If you use a bidirectional filter in RLS that propagates to products with a M2M *without* passing through the fact table, it works well. If you enable RLS with the bidirectional filter going through the fact table, it works the same (using the method described) because the security is applied *before* anything else. Security is guaranteed to work. But the price to pay is high. Every query is much slower because of this security design. Try to filter the Products without having to use the fact table as an intermediate table to obtain the result you want.
Dears Once I publish and share a report in my a workspace with other team members, I get very often their slider selection when I go in the report. Is there a way to make sure all slicer are back to original selection when we close the report? Many thanks
Great video! would this measure still work if used slicer sync? I noticed when using slicer sync, if make a selection in slicer 1, it will make the selection in slicer 2, but it is no longer filtered to show the available options. All options remain.
Is there any reason this wouldn't work? I have tried both methods and still my slicer contains options that return an empty table! They just won't disappear. Can page filters override this? Am I missing something? My report is not user friendly because of this and is driving me crazy
It might depend on the measures or on filter propagation between visuals. Try on an empty report adding one element at a time, use the sample you can download from the article and try to isolate what is causing the issue.
What if you want to sync the category between the chart and the slicer. That measure wont work, because it filters trough the same column, therefore its always isempty is always false.
When I have two fact tables, can I do the following to check both? Slicer = INT (OR (NOT ISEMPTY ('fact1'); NOT ISEMPTY (fact2))) Thank you very much for sharing information.
Thanks for reporting - we just updated the description including a link. Here is the same link for your convenience: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-x3m7qzsVJqQ.html
Sir, I am facing an issue this case. What if I had selected one of the items from my second slicer and then change my option from the first slicer? The selection from my second slicer does not go away unless I deselect it myself... Please suggest.
Ciao Alberto. A tiny detail, but it's bugging me. So when I copied your method for creating an empty table, Slicers = FILTER ( { 1 }, FALSE ), I wound up with a column called "Value" and no obvious way of deleting it. This "Value" column is not in your table so what am I missing please? I love the idea of not cluttering things up further in Power Query by using "Enter Data".
Actually... it is there, just hidden. I don't think it is possible to create a table without columns at all... I can feel your pain, it hurts. But it is what it is :)
It's helping but when i remove the selected value from first slicer, all values are not coming in the other slicer. Any help would really be appreciated @sqlbi @alberto
