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.
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.
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...
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??
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'.
@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
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!
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). :)
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!
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 ;)
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)
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 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
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!
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...
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
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.
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 ?
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
@@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!
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 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?
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?
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 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?
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?
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 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."
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!!!
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. ?
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!
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.
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
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
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.
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.
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?
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 :)
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 ..
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.
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.
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.
This is cool, but how can you setup a default slicer selection ... for example, Accessories, Bikes, Clothing, Components and Not Applicable are in the slicer ... if none are selected, then default the slicer selection to Not Applicable. The business case scenario that I have is that I have a page that contains point-in-time data (not trend data) for a particular business quarter. The data has current quarter and all historical quarters. When a user opens the report, all of the information of the page represents numbers of a given quarter, as driven by the slicer selection; however, initially, the slice has no selection. I'm not sure how to default a slicer value to a particular value (e.g. MAX(FiscalQuarter) ). NOTE: I do NOT want to have this quarter slicer to only have the current quarter. I want the user to still be able to select historical quarters, so that they can change the report view to a historical view, but on the initial page load, they see the most recent quarter's information. I know I have seen some very kludgy examples out there, I would like to find a clean way if possible. To be completely frank, I'm shocked an disappointed that such a default setting isn't built into the slicer control, as this is a pretty standard property for most other GUI programming languages (and hopefully something that M$ addresses in the near future).
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 ?
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!
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
when l select the blank value everything works on my slicer but if l don't select the blank value nothing is populated in my slicer .. anyone help please!!
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.
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😘
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!
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.
Awesome. My fav PowerBI youtube channel. Whenever am stuck with bug or development, i come here. Great keep doing this.
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.
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.
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...
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??
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
@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
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!
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). :)
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!
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 ;)
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!!
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?
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)
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
Love your quick, down to the point, effective videos !, this tip is awesome !
Thanks for sharing the tips. Can you also show how to tackle this issue when we have multiple slicers for one Visual?
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
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!
Excelent Tip! Thank you very much, i ll use it in my report
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.
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
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.
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 ?
But ..after using this... When I select all in the slicer .. then visual is showing blank
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
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!
Hi Patrick, it worked great for me, thanks. You help me to solve an issue.
Incriveble!! You're insane in Power Bi! Thanks!!!
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.
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 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!
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 ?
Thank you! Simple and solve my problem.
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"
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?
How did you do the blue indicator above the visual!? I'd love to learn how to do it
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?
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
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."
I tried do this with a Slicer versus Card, and unfortunately doesn't works! Anybody have some idea?
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!!!
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.
?
you just earned a new subscriber today. thanks 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!
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.
This is good and followed what you have done but my visual did not work. It still behaves the same as default
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.
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?
Can we drive the data to slicer by selecting a record over table visual?
Hi great video, but this doesn't seem to work on a card visual. Could you please resolve that problem/mystery?
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
Not working on a multi card visual, as the measure breakdown is frozen, What to do in that scenario
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
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.
That's fantastic for certain use cases.
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.
Short yet extremely helpful.
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?
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 :)
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 ..
Thanks for the video!
Brilliant! Thank you very much.
Can you do this with a card visual instead of a graph?
Did you find a way to do this
i need help
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.
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.
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...
Isn't it possible to omit the INT() and use IsCatFiltered equals true (instead of 1) Would save the INT() calculation, wouldn't it? 🤔
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
How do you create a measure, where are you typing code etc
and while your at it, stop pointing at everything
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.
This is cool, but how can you setup a default slicer selection ... for example, Accessories, Bikes, Clothing, Components and Not Applicable are in the slicer ... if none are selected, then default the slicer selection to Not Applicable.
The business case scenario that I have is that I have a page that contains point-in-time data (not trend data) for a particular business quarter. The data has current quarter and all historical quarters. When a user opens the report, all of the information of the page represents numbers of a given quarter, as driven by the slicer selection; however, initially, the slice has no selection. I'm not sure how to default a slicer value to a particular value (e.g. MAX(FiscalQuarter) ). NOTE: I do NOT want to have this quarter slicer to only have the current quarter. I want the user to still be able to select historical quarters, so that they can change the report view to a historical view, but on the initial page load, they see the most recent quarter's information.
I know I have seen some very kludgy examples out there, I would like to find a clean way if possible. To be completely frank, I'm shocked an disappointed that such a default setting isn't built into the slicer control, as this is a pretty standard property for most other GUI programming languages (and hopefully something that M$ addresses in the near future).
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 ?
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!
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
Thanks!
when l select the blank value everything works on my slicer but if l don't select the blank value nothing is populated in my slicer .. anyone help please!!
Thank you so much 😇
Hey, can I do sumifs in PowerBI without grouping tables? as I need my raw data as is?
I struggle how to make this work for a matrix, is it just not possible or has anyone found a trick?
Q: Do you know how to apply this to matrix tables and what about measures that combine information into one?
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.
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
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😘
Helped alot thanks
I finally got it to work but I needed to use a disconnected slicer for the filter.
Thank you
this helped, thank you so much..
Simple but amazing tip !!
Is there a way of doing it in a dashboard using a Direct Query connection?
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
Can you help me how to capture the from and to value of a numeric range slicer in power bi
Lovely trick
Cool light one!
This doesn't seem to work at all for rows in a matrix. Anyone tried it? Have an answer?