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 thought you we're reposting videos as every other TH-cam 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 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
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!
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.
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
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].
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.
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.
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.
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.
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/
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.
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?
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 :)
Thanks for reporting - we just updated the description including a link. Here is the same link for your convenience: th-cam.com/video/x3m7qzsVJqQ/w-d-xo.html
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
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.
Mr. Ferrari, you are a Master Jedi of PBI.
I have no words to thank you.
Hands down, you & Marco are the best channel for PBI period
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!!!!
Alberto Ferrari , thank you very much for this yet another high quality instruction and training video !!!
I Love You .. this video and another one "BiDirection and Ambiguity" enabled our project to continue its path .. many many thanks
I thought you we're reposting videos as every other TH-cam 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!
Very useful modeling technique in financial modeling where based on account selection, show only relevant departments which contain data.
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!
This puts great definition and structure around measures as filters for slicers.
WoW.. This is great trick .. Loved it ♥.. Thank you @Alberto and @SQLBI 😊
As always Alberto, brilliant
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 very much for the video Alberto!
Amazing videos! Thank you so much for all the helpful content.
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
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!
Thank you Alberto for another great video! Can I ask the make and model of your keyboard you are using in the videos?
Sure. It's a WASD V3 keyboard. They let you choose keycap colors, and I came out with that choice :)
Thank you Alberto; that's extremeley useful!
Next. Level. Period.
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.
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
Thank you 👍🏻 Perfect Dax to cross function two slicers
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].
If I don't recall wrong, Excel does it automatically (even though, last time I tried, it was terribly slow if you left the feature enabled).
This is very informative, Sir.
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.
Did you find a solution to this problem? I have the same issue.
Really your concepts are very helpful in work👍
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.
You should apply the measure filter to each slicer.
@@SQLBI thanks! I will give that a try!
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.
great as usual thx. my question: is there somehow a way to convert this approach into syncing slicers with "and logic" ?
Can you pls let me know why slider and slicer not working togather
How we can do the same filtering for card charts? I tried but it didn't work
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.
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/
Thanks for the clear explanation.
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.
Yes - you can also write:
NOT ( ISEMPTY ( fact1 ) && ISEMPTY ( fact2 ) ... )
which is just easier to expand if you add other fact tables.
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?
Thanks Alberto - Can you put a measure into a slicer, say GP% on product sales and filter GP%
Very Informative video!
Ciao Friend!
I love your videos.
Grazie mille!
You go Alberto!
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 :)
Does anyone have a link to the previous video?
Thanks for reporting - we just updated the description including a link.
Here is the same link for your convenience: th-cam.com/video/x3m7qzsVJqQ/w-d-xo.html
Did I say it yet? I love this!
Awesome 👍
Thanks, This video is very useful for me
Ho visto qualche mese fa la medesima soluzione su un sito, dopo mesi di arrovellamento... Come se avessi visto un'apparizione.
Thanks
Thanks a lot!!!!
Nice one!
Thanks.
Nice ideaa
10xxx
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