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.
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.
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.
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.
Hi, Thank you for all the knowledge shared...You guys are doing great. I have similar use case where If I select 1st slicer (Month/Year) then in the second slicer I want to show start date and end date, but it should be grayed out which will be non-selectable and visible so that end user knows how many dates are available in that specific Month/Year...is it possible if so please make video on the same soon...Thanks in advance...
Not sure if you've found this solution yet, but what I've just done works. 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!
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.
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!
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
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). :)
@@akpokemon if your after a solution for the card this can help! Not sure if you've found this solution yet, but what I've just done works. 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!
Came here because, like many PBI devs, I'm trying to address a basic flaw with the table visual that causes it to throw an error when there's "too many" records in the dataset behind the visual. There should be a visual option to suppress displaying results for several conditions (ie, >10k records, specific(!) slicers not filtered, etc). The isFiltered function only checks if the table of the referenced column is being filtered, not that the slicer for that column has a value. This means if any other slicer or cross-referenced visual is filtering the table that the referenced column is in, the function returns "true". That includes a date-range slicer, which puts the table into permanent filtered state.
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
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)
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 ;)
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??
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
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
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?
@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
If I want 5 different slicers to be selected before showing the visual - do I have to create 5 different Int-isfiltered measures? Or is there a way to have all 5 slicers referenced in one measure?
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.
Not sure why exactly, but when I try this exercise , and drag the measure onto a visual(table, slicer or card), the dropdown on the filter is frozen.. can't make any selection. I have no idea why at the moment..
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?
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. ?
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 ..
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.
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
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'.
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!
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!
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.
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 ?
You would would add a card with measure containing text to display and overlap on Visual. When something is selected, make it transparent using another measure.
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, 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 :)
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.
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!!!
This only works when you select the slicer; but when you select other visual, the visual applied this filter will not interact with other visual anymore.
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.
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 ?
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
It doesn't really work when selected all option is added in the slicer. when select all is chosen. The isfilterd also returns false and turns the interger to 0.
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?
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."
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?
I have a bar chart with countries and units sold . In smart narrative when nothing is selected it still shows any random country but with correct total units for all countries. Plz advise bro😘
Hi Patrick! Is it possible to single select a quarter from a slicer but then always show five quarters of detail rows (starting with the selected quarter) in the table visual? For example, if I select Q3-2022, I want the table visual to show all rows for Q3-2022 to Q3-2023 (07/01/22 to 09/30/23). If this is doable, I would appreciate very much any guidance on how to go about it. Thanks in advance!
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!
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?
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
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, 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
Can this be done with the new card? I'm trying to get it display nothing in the card until I select a row in a table (that has multiple values, including the one i want it to dispay on the card at selection.)
Not sure if you've found this solution yet, but what I've just done works. 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!
This doesn't seem to work anymore. :( When I use this it seems that the "Apply filter to visual" won't allow me change the value or even the "Is less than" default option.
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.
This needs major upvotes. Your second point solved my issue!
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.
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.
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!!
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.
Hi,
Thank you for all the knowledge shared...You guys are doing great.
I have similar use case where If I select 1st slicer (Month/Year) then in the second slicer I want to show start date and end date, but it should be grayed out which will be non-selectable and visible so that end user knows how many dates are available in that specific Month/Year...is it possible if so please make video on the same soon...Thanks in advance...
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".
I got the same thing. Got any solution for that?
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?
Not sure if you've found this solution yet, but what I've just done works. 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!
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.
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!
Love your quick, down to the point, effective videos !, this tip is awesome !
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
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). :)
Its great help, But this filter is not working on Matrix visual, Card Visual and Bar Chat. Can you help ?
Did you find a soltuion? It's absolutely infuriating that this can only be applied to _certain_ arbitrary visuals, instead of any visual...
@@akpokemon if your after a solution for the card this can help!
Not sure if you've found this solution yet, but what I've just done works. 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!
Came here because, like many PBI devs, I'm trying to address a basic flaw with the table visual that causes it to throw an error when there's "too many" records in the dataset behind the visual. There should be a visual option to suppress displaying results for several conditions (ie, >10k records, specific(!) slicers not filtered, etc).
The isFiltered function only checks if the table of the referenced column is being filtered, not that the slicer for that column has a value. This means if any other slicer or cross-referenced visual is filtering the table that the referenced column is in, the function returns "true". That includes a date-range slicer, which puts the table into permanent filtered state.
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
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)
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...
Hi Bryon! How do you make it work for the card as you described here?
@@enfafil1 I take it back - it didn't work! I was thinking we could just do the same and use the same 0/1 filter for displaying the card.
Excelent Tip! Thank you very much, i ll use it in my report
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 ;)
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??
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
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
Thanks for sharing the tips. Can you also show how to tackle this issue when we have multiple slicers for one Visual?
How did you do the blue indicator above the visual!? I'd love to learn how to do it
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?
Hey @xplicit4581, having the same issue. Have you found a way to solve it ?
Incriveble!! You're insane in Power Bi! Thanks!!!
@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
Q: Do you know how to apply this to matrix tables and what about measures that combine information into one?
If I want 5 different slicers to be selected before showing the visual - do I have to create 5 different Int-isfiltered measures? Or is there a way to have all 5 slicers referenced in one measure?
Can we drive the data to slicer by selecting a record over table visual?
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.
Not sure why exactly, but when I try this exercise , and drag the measure onto a visual(table, slicer or card), the dropdown on the filter is frozen.. can't make any selection. I have no idea why at the moment..
Can you do this with a card visual instead of a graph?
Did you find a way to do this
i need help
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?
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.
?
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 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 ..
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.
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
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'.
share it please
I did something similar as well. Included textbox with warning messages and warning message in the title of dependent slicers
Not working on a multi card visual, as the measure breakdown is frozen, What to do in that scenario
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!
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).
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!
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.
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.
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 ?
Is it possible to have a message in the visual if nothing is selected? Something like “select a category in the slicer”
You would would add a card with measure containing text to display and overlap on Visual. When something is selected, make it transparent using another measure.
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!
Could you please explain as I am unable to edit this measure in the filter visual to "is"
But ..after using this... When I select all in the slicer .. then visual is showing blank
you just earned a new subscriber today. thanks so much!
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 :)
I tried do this with a Slicer versus Card, and unfortunately doesn't works! Anybody have some idea?
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.
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!!!
This only works when you select the slicer; but when you select other visual, the visual applied this filter will not interact with other visual anymore.
Hi great video, but this doesn't seem to work on a card visual. Could you please resolve that problem/mystery?
Can you help me how to capture the from and to value of a numeric range slicer in power bi
Please can you enable select all option in the slicer and check if ISFILTERED() is working when Select All option is selected
Can we do this using table, no slicer? Table to Table...
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.
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 ?
This is good and followed what you have done but my visual did not work. It still behaves the same as default
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
It doesn't really work when selected all option is added in the slicer. when select all is chosen. The isfilterd also returns false and turns the interger to 0.
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?
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?
I finally got it to work but I needed to use a disconnected slicer for the filter.
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."
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?
I have a bar chart with countries and units sold . In smart narrative when nothing is selected it still shows any random country but with correct total units for all countries. Plz advise bro😘
Hi Patrick! Is it possible to single select a quarter from a slicer but then always show five quarters of detail rows (starting with the selected quarter) in the table visual? For example, if I select Q3-2022, I want the table visual to show all rows for Q3-2022 to Q3-2023 (07/01/22 to 09/30/23). If this is doable, I would appreciate very much any guidance on how to go about it. Thanks in advance!
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
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
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!
Thank you! Simple and solve my problem.
Hi Patrick, it worked great for me, thanks. You help me to solve an issue.
Is there a way of doing it in a dashboard using a Direct Query connection?
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?
I need this solution too!
Hey, can I do sumifs in PowerBI without grouping tables? as I need my raw data as is?
Isn't it possible to omit the INT() and use IsCatFiltered equals true (instead of 1) Would save the INT() calculation, wouldn't it? 🤔
How do you create a measure, where are you typing code etc
and while your at it, stop pointing at everything
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
You can use 2 conditions: 1 checks for 1 value selected, the other checks if nothing is selected then do the logic
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, 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
Short yet extremely helpful.
Hey Patrick please point me to video where I can set default settings in slicer
Really cool stuff, but why doesn't work for Card or Multi-row Card visuals? is there a way?
Did you find answer to this please share i need it
Doesn't scale well for large direct query tables. Would be cool if there was a native way to do this.
great. too bad it doesnt seem to work on all visuals. specifically the gauge and card visuals.
ya i have the same issue and need it to work on cards :S,No Luck :(
try to use the is filtered function in the same measure you are using it to fill the card...it worked for me
how to apply for date range slicer
this i s not work in card what do i do about that?
Simple but amazing tip !!
That's fantastic for certain use cases.
Can this be done with the new card? I'm trying to get it display nothing in the card until I select a row in a table (that has multiple values, including the one i want it to dispay on the card at selection.)
Not sure if you've found this solution yet, but what I've just done works. 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!
For card visuals it will not work. Can you please show another solution
This doesn't seem to work anymore. :( When I use this it seems that the "Apply filter to visual" won't allow me change the value or even the "Is less than" default option.
Appears to be a limitation if a visualization doesn't specifically include the filtered field in the list of fields to visualize.
Q:Can any one help how to hide matrix table values when there is noselection on slicer