Dude I was proud to think that I was the only one who came to this brilliant idea 😂 But I didn't stop there, also added two cool triggers inside the same visual: 'Please make a slicer selection' and 'No data available for this category'.

Notes to self: - It has to be INT(...) and not the boolean directly because of a bug. Bool measures just wont filter the visual (dropdown is frozen). - This thing implies that the chart is not using the field on the slicer. If the chart uses the slicer, the two filters get mixed and wont do what you wanted. - ISFILTERED returns false if you have not selected anything, but also when you "select all". It's not about the cosmetics of the slicer. It's about the data model.

Awesome. My fav PowerBI youtube channel. Whenever am stuck with bug or development, i come here. Great keep doing this.

Thank you for this. Largely resolve the problem. To give some context for everyone. I have a year slicer and a company slicer ( not the same table ) If there is no year selected the entire report is blank . I ended up adding the IsYear filtered to my second slicer for company selection. This made the logic flow work of selecting you reporting year then the company ( it can work either way ) The exception is a matrix with a drill down column. I created an IsCompany filter but that visual shows data and only stops shows when year is blank Anyway, was super cool of you to help me out like this and expand the general info out there.

That's banana! Thanks for the tips! To "avoid" filtering upstream, I prefer simply use "Edit Interaction" to disable the interaction to the destinated filter(s). :)

Love your quick, down to the point, effective videos !, this tip is awesome !

doesn't work for me, i add to my filters but i can't change the drop down in the filter itself to enter "1".

Thank you yet again. Have done something similiar in past, but this takes why I achieved even futher. And INT(ISFILTERED()) is pure gold. Thanks Andreas!

I'm pretty new to Power BI and has been stuck with this and had to implement it. Thank you you're a life saver!!

How to make a slicer that effects one visual. The idea is to create two visuals having the same measure, the left slicer affects the left visual and the right slicer affetcs the right visual ; this way I can compare the sale of one product in two different years and compare discounts and other stuff. It's more of a simulation than simply showing data. Amaizing video Thank you very much.

Great tip! You could also add a card visual with some text like "Please select from the filter!" and have it being displayed when the flag is 0 - that way the user knows they have to do something, rather than just having a large empty space...

I have looked for something similar for case when you have multiple slicers (I have 11!). So, I created measure with to variables: TotalNumberOfRows = Calculate( Countrows(Fact_Table), ALL()) FiltredNumberOfRows = Calculate( Countrows(Fact_Table)) RETURN(TotalNumberOfRows-FiltredNumberOfRows=0,0,1) Not sure about performance, but now it works ;)

A thing that I normally do for that case is add an explanation in red & bold text on the graph: " To display data choose something in the slicer". That way people don't get confused thinking it's empty space. (I display a measure on a card "under the graph", the measure returns an empty character when there is something selected. If you place it over the graph it will prevent things from being highlighted on the graph). I hope this makes sense

this is great for the multiple graphs visuals I have, but it does not seem to work when using card visuals. Does anyone know a resolution for this?

Yoooo great video thanks for sharing. In case anyone else like me stumbled on here for a solution to applying this to card visuals, please see my comment below: If you change your card visual to "Multi-Row Card" in the "fields" section drop down, select "don't summarize" then you'll be able to change the "Show items when the value" to "is". For some reason you can't alter this on a normal card old or new!

Hi Patrick, this approach works only for small visuals. I have an Ad hoc table with two slicers, one for dimensions and another for measures. With such conditions, the table doesn't show anything, but it still makes calculations. Due to this reason, I often get the message "Lack of memory," etc. I guess I need to add dummy values for both slicers and select them by default. After this, I will change the condition to show data if the selection does not equal the dummy columns.

Excelent Tip! Thank you very much, i ll use it in my report

@Guy in a Cube I might be a little late to this party. In my case, I have a matrix that displays some values and a separate table that does some math base on my selection on this matrix. So my slicer is not an actual slicer, but it serves the same purpose in practice. So, when I'm selecting a value from the matrix, it is indeed filtering the values I want to add in the table just fine. However, when I haven't picked any values, it's adding absolutely everything which doesn't make much sense to my report. I want that the report behaves in a way that when I haven't selected any values from the matrix, it doesn't display any values to be added to the table doing the math. When I use this method, ISFILTERED still displays FALSE whether I'm selecting something in the matrix or not. This is simply a software limitation because even though the visuals are indeed being filtered, ISFILTERED only evaluates if the relevant arguments are being filtered specificaly by a slicer. Do you have any idea what I can do? I added a small video but snipping tool didn't capture what I really wanted it to. However, you can see the two selected values are indeed being filtered in the table above. However the FILTER CHECK shows "FALSE" like if nothing was being filtered. "Potencial" in the matrix and "Sum of baseamount" in the table are exactly the same field fromt the same table. When I deselect the two values, I'd like the column sum of baseamount to remain blank, instead it adds up absolutely all values from the matrix. drive.google.com/file/d/1NfWW24qXvQ1QfRiDcLd5VB_YWJSJFc7p/view?usp=sharing P.S. I'm sorry for the quaity of the video. It's absolutely terrible after uploading it to GoogleDrive. I hope my explanation makes sense though. Hope you can enlighten me

Hi Patrick and Adam, Great content as always. I was wondering if you can create a video on How to distribute Power BI reports with large audience, best practises of it, how to manage the dataset accesses, report accesses & Power BI Apps accesses effectively, that would be great. And also, even sometimes if the dataset or dataflow owner is not available in organization anymore, then how can we manage take over part or is it possible to organize this with Service Principals, Any automation using Power Automate, etc. Basically a report distribution life cycle after report creation, with all the smart work involved in it. Thanks and regards, Rohit

Incriveble!! You're insane in Power Bi! Thanks!!!

The cross-highlighting thingy Patrick is talking about at 2:55 is why I hate slicers so much. My reports could always benefit from interconnected slicers but the cross-highlighting mess makes it impossible to use. I would go as far as to label this a design flaw in slicers which I hope someday they will fix.

you just earned a new subscriber today. thanks so much!

Its great help, But this filter is not working on Matrix visual, Card Visual and Bar Chat. Can you help ?

Quite nice! Doesn't work though if you want to see the categories in the visual (in this case Category is always regarded as filtered).

Hi Patrick, it worked great for me, thanks. You help me to solve an issue.

Thank you! Simple and solve my problem.

But ..after using this... When I select all in the slicer .. then visual is showing blank

Thanks for sharing the tips. Can you also show how to tackle this issue when we have multiple slicers for one Visual?

I tried do this with a Slicer versus Card, and unfortunately doesn't works! Anybody have some idea?

Awesome! It works BUT I can't add that measure as a filter for the entire page or all pages. It can only be added in a particular visual (or add to each visual individually)

Awesome feature and this helps a step forward in visualization Thank you But how to apply for Visual ID Card tile, tried many ways but unable to solve it Can you please guide me on this Thank you in advance

Short yet extremely helpful.

Thanks for the tip. however, having converted my calculated measure into a slicer it works perfectly but whenever I clicked on the clear selections icon on the slicer, all my rows and columns returned blank

Thank you! I was looking for a solution everywhere, and this made it so easy. I ran into one issue though... it didn't seem to work for me when I applied it as a filter to a multi-row card visual.... any thoughts on why this might be the case??

Thank you! This is the best PBI channel, congrats! Just one question, I am trying to use it with Cards, but It doesn't allow me. Is there any other way to work with cards? (in my example, I have specific customer information on a card (Active and Inactive) and I don't want it to pick the first record considering all customers. Thank you!

Can you do this with a card visual instead of a graph?

Hello Patrick, first thing first, just wanna tell you that you rock the entire Power BI community :) I'm currently facing a challenge and it's fixing the selected value in a slicer. Basically, I have a slicer that shows purchase year (unique value selection), and I want the selected value to be the latest whenever the report is refreshed (for now the selected value is the one the last used picked). Is that something you've dealt with in the past ?

That's fantastic for certain use cases.

Thanks

Brilliant! Thank you very much.

I finally got it to work but I needed to use a disconnected slicer for the filter.

Can we drive the data to slicer by selecting a record over table visual?

Been looking for this for so long, thank you! But I have an additional question. I want to use this filter in a card where a date or value (min of) is shown (for a contract for example). I can add the measure to the visual but I can’t change that measure in the filter. Is there any way to make this work?

Hi Patrick, can you make a video to show how to control days between stages in a sales process? I have one fact table with different phases before achieving a sale, but want to measure the average days between the keep track of SLA. Thanks and great job!!!

Thanks for the video!

How did you do the blue indicator above the visual!? I'd love to learn how to do it

Is it possible to have a message in the visual if nothing is selected? Something like “select a category in the slicer”

Simple but amazing tip !!

this helped, thank you so much..

I did a relationship between two tables, but the other table, whenever i choose one of the table fields it shows no value it's blank, i saw almost every Power Bi developer they don't talk about it

I have been trying to do this with multiple dynamic parameters. I had to correct a field call no selection and set it " ". However my row counter doesn't work when counting on multiple dynamic parameters created from one flat file.

This is good and followed what you have done but my visual did not work. It still behaves the same as default

Thank you so much 😇

That DAX keeps visuals such as bar charts from loading, if no filter used, ok. But it seems that this does not work for simple tables. They will always load. How can I use this way to keep tables from loading as well? Or is there a different solution? Thanks alot!

Thank you!!

Hi guys, great content as always. I don't suppose you have found a way to hide or un-select the previously selected option in a slicer, when a higher heirarchal option is selected in the other slicer?

is there any workaround in case of paymeasure too? with this solution I am able to filter the table but the headers are still there in table.

One issue that I have been facing is that if I have nested slicers and I have something selected in upstream and downstream slicer then changing selection in upstream slicer changes selection option in downstream slicer but retain one option from previous selection also.

What about date slicers, is there some magic trick for reports showing prior month visuals or results. is it possible to notify the user " hey this is last months view, change the date slicer to see the latest results" Thank you for you amazing, engaging teaching style.

How can you do this for cards because I tried but doesn't give me the option to change to ''is'' or to fill in an number in the filter beam?

Hi great video, but this doesn't seem to work on a card visual. Could you please resolve that problem/mystery?

Not working on a multi card visual, as the measure breakdown is frozen, What to do in that scenario

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 isfiltered is always true.

Hi Patrick this video is great. Could you please make a video that how to capture paginated report DAX queries when we run the report. If my report run slow I need to know how to check what is making it slow?

Helped alot thanks

Thank you

So what if I want to add the 'Select All' option to my slicer and have the same result? Meaning I don't want anything in the table(s) until a selection is made in the slicer, whether it be the select all option or a single selection.

Q: Do you know how to apply this to matrix tables and what about measures that combine information into one?

This was a great video helped a lot /the only problem is / I’m not using a slicer/ I’m using a text filter and it won’t work with a text filter any advice?

Hi How are you I have a problem can you help me When I select the 'All Selection' option in my report, the charts do not respond as expected. It seems that 'All Selection' is being interpreted as a null selection. The function I am using is as follows: "dax" Fitradomarch = IF ( ISFILTERED('March'[Sistema]) && ISFILTERED('March'[Year]) && ISFILTERED('d.calendario'[Months]), 1, " " ) This function checks if the fields 'Sistema', 'Year', and 'Months' are filtered and returns 1 if all the filters are applied, or a blank space otherwise. I am trying to find a solution to deal with this issue because it occurs due to the filter containing the 'All Selection' option. I am asking for help."

How do you create a measure, where are you typing code etc and while your at it, stop pointing at everything

Lovely trick

Please can you enable select all option in the slicer and check if ISFILTERED() is working when Select All option is selected

Great video as usual guys! One question about the permissions on the service. I have troubles to find out how to set up an edit right for a report which is not in an app, is in a workspace to which I don't want to give a user contributor rights - no need that the user should see a content of the whole workspace. The user has rights over the dataset which is actually saved in a different workspace and has also an app. the report is basically a testing report in testing environment created from a published dataset in a different workspace. Seems like it's not possible even in 2022? Any ideas?

Thanks alot! but how can I return a string of "NO FILTER IS SELECTED" on text and also when select to show the string selected

Hi Patrick Thanks for nice video. Really helpful. I have a question & problem. Would be great if you can explain how to do that.. Question ; I have an excel table for projects, about 100.000 rows, with 10 columns that specifies the project specs. Question is ; In Power BI, i will choose one project from table then i would like to find most similar projects from main excel table according to similarity based on column data (each column will have weighted similarity factor & column context can be number & text). And then i will filter & list them based on more similar project to less similar project by similarity score. ?

Does this only work using slicers? I have a filled map that I want to use as my "state selection" rather than a slicer, but I can't seem to make this work when selecting a state to only show the values that are within that state.

Thanks! Getting a blank option added to the list of slicer after using this tip. Any suggestions how to avoid it? I have made sure that in the join there is no unrelated data

Thanks!

Cool light one!

Hi A/P great content, When we select Drop Down in slicer than "All" option is not getting hide, as we can see in larger list, Can you please explain if that is possible ..

Hey, can I do sumifs in PowerBI without grouping tables? as I need my raw data as is?

I have a table visual that needs this feature. But the problem is I also have category field in values of the table. So this does not work. Any workaround if category column is included in visual field list ?

amazing. only one in internet explains this

You are awesome....

Doesn't scale well for large direct query tables. Would be cool if there was a native way to do this.

that's soo cool and useful, thanks

Can we do this using table, no slicer? Table to Table...

Isn't it possible to omit the INT() and use IsCatFiltered equals true (instead of 1) Would save the INT() calculation, wouldn't it? 🤔

Hi Patrick, thanks for this - but I still have a problem with it. It works as you have shown it for me as an admin, but I have a report using RLS, and lets say for example "Person A" opens a report which shows them data for "Department C", my RLS defines that the report opens up automatically showing them data for "Department C", but the Dept C isn't necessarily selected in the slicer so the visual is still blank. How would I get around this problem ? Thank you so much in advance :)

this approach still sends over the dax query to shared dataset for calculations. Is there a way to tell it not to send the dax query to the server if isfiltered returns false?

Hello, what is the way to export a well formatted table from power bi to excel file? It gives only csv option which removes all the formatting

What if you do “select all” on that slicer with categories? From what I remember it would also be treated as not filtered therefore it would not show any values

great. too bad it doesnt seem to work on all visuals. specifically the gauge and card visuals.

Not sure if this is the best place to ask this question but I figured why not try. I have a request to build a few reports using a SOAP API. I haven't found any good resources or tutorials on this. Any help here would be greatly appreciated!

this i s not work in card what do i do about that?

Is there a way of doing it in a dashboard using a Direct Query connection?

Can you help me how to capture the from and to value of a numeric range slicer in power bi

For card visuals it will not work. Can you please show another solution

Hi, thanks for your video. I have a question. I have 3 stages, Concept, Plan and Execution, for my project, I have put them in a filter in excel, now currently all activities are in the Concept stage, I want to show all the stages on the dashboard even though at present all activities are in the Concept stage, I want the dashboard to show all the other stages. I tried the option "Show all items with no data", but that doesn't work, any help please, thanks