Awesome idea Bas... The other day someone asked me how to disable a slicer and I told them it is not possible with UI alone. But I am going to point them to this video now :)
This is so hilariously simple, but so useful. I have so many workarounds I've used in the past (like bookmarks) to accomplish this, but never thought about it this way. Love the slicer header trick as well! Thanks so much Bas!
Hi Bas / @HowtoPowerBI Thanks for the detailed video. I have implemented similar solutions in the past. However, with my solution, the slicers conflicted and returned incorrect results when the Period slicer is disabled and the date range slicer is selected (for example, the last 3 months from January to March). After this, when L12M is selected, it retains filters from both the Date Range slicer and the Period slicer, showing only the last 3 months. How does the behavior in your implementation differ? Could you please clarify? Thanks a lot for this and all other videos. Much appreciated.
Hi Bas, good one again. Many thanks - I succesfully implemented it into my reports. One isue is that when a selection is made in the second slicer when active, the selection in the second slicer remains in place when moving to a disabling category in slicer 1. I have tried to find a way out of that but so far unsuccesfull. Any sugestion for solutions for this from your end?
Yes, similar issue happened for me as well...when 2nd Date Range is enabled and is date is selected and after that return to slicer 1 and selects any value...2nd slicer selection remains....any solution/ideas will be much appreciated. Thank you.
Hello sir, thank you for this video and idea ! Works perfect with these two types of slicers, but i m working on project right now where i use dropdown slicers and it actaully makes a difference, but im still able to "open" dropdown slicer but i see nothing there using your method, which works fine but is it somehow possible to disable dropdown slicer the same way how you did that with date slicer ? My last question is, is this possible with buttons aswell ? tu use measures to disable and enable buttons in powerBI ? Thanks for your contet and have nice day !
Thank you. Very useful. I am a beginner and although I have already created several reports I have always wondered how exactly to do this Very well explained Cheers from Barcelona
We are using this and have a Custom option in the date period selector, this will make things a lot neater. The one thing we have not gotten right is resetting the date slider when flipping between date periods.nneed to hit the eraser and then the period, given the text bit I think it will still affect this, likely this will help others who use this, unless this works without that
Great video! Just one thing, if we have a selection in promotion slicer and than we select cataloge store, it will not deselect the selection in promotion slicer, right? How to handle it?
Nice techniques for UX. However, dont you think if we have multiple slicers with such functionality & also several visuals with similar UX techniques which invlove creation of custom measure/columns / buttons / bookmarks / interactions, etc would make the report more complex to manage when someone would want to make changes to report after few months or if report is handed over to a different developer to enhance or maintain ? Thanks
great video i have implemented same kind of logic in my recent development .. but changing the colour and text of visual is the cherry on cake .. will be implementing the same as well.. thank you
Thank, this is really nice. But is there a way to also automatically apply deselection on the slicer which is being disabled ? In this solution, the selection which was made in the first slicer, still remains active, even after that slicer was disabled, by making a selection in the second one. This can result in the wrong number being shown (for example 6M period will be partially filtered by other selection in the disabled date slicer, which would not be expected by the user)?
That is one way to go. However, bookmarks scale multiplicative. Let's assume that you have 4 bookmarks. If you add some another factor, which needs 2 more Bookmarks for different states (like 2 different chart types or showing/hiding side panel for ex), you will end up creating 2x4 = 8 bookmarks. And that gets increasingly out of control very fast.
Hi Bas glad to watch ur awesome new videos again, just a question please. Inside your report you have a measure used as a filter that is the "Customer Period Filter", inside there you have this VAR: VAR _MinDate = EOMONTH( _MaxDate , _MoveMonths ) + 1 Can you please explain me what the +1 refers to? Thanks in advance
Hi, thank you very much for the solution......now a question, as you left your date filter with those bars at the bottom, mine only shows those circles haha.......I'm referring to the date range dates.
Bas, thanks for the trick! Is the line chart continuous or categorical? I can see it is a time series on X-axis which generally is plotted on a continuous line chart. But you have breaks in the line chart which is not possible in Power BI (unlike Tableau) ... This is required especially for sensor data where the sensor value is missing for certain date-time values.
Once again a very informative and clear video! 👌💪👏 Correct me if I'm wrong but on Excel slicers it's a native feature to hide value with no data. Weird it's not native on PowerBI ?
This is really smart! I thought it was going to solve my issue, but it's just off. I have 2 slicers that I'm experiencing this problem with but they're both referencing the same field. The reason is they wanted a quick date slicer to choose custom number of weeks and such but also want to be able to easily toggle custom date ranges(with the between type of slicer), so this solution doesn't work. From the comments, I may try an old school bookmark though
is there a way for you to duplicate this field but name differently? I think you can reuse the described above approach but you just need to separate the fields by creating the second one as a date table
Disabling the slicer does not clear the previously selected values in it. So if you were to filter on date range, and then select a period, the filtered date range values are still in effect, and therefore the selected period could falsely represent the amounts. Is there a way to make the "disabled" slicer go back to default or be cleared, when the other slicer it depends on is being filtered?
I tried this method and it works great on the desktop but when I publish to the service the date slicer still allows the user to click on the date to select a date, it just doesn’t actually filter anything. Was very confusing for the users
That’s really useful. What will happen if two or more values selected in the Period slicer? And can we make it dynamic for the promotion slicer if it does not exist for the selected Store?
You could also add your periods and a "custom" option with forced selection, only downside here is the user needs to click the eraser on the slider when switching to a fixed period
Is there any way to disable 3rd value selection in a same slicer because i want to restrict user to select only two state at a time if user try to select third value from same slicer slicer gets disable
Can it be true there is no file to download? i cant find it on the page after clicking on the link. I did try type in my information. I couldnt sign in either, it said "registration has been disabled"
I have a similar setup but with a Year slicer and a Date slicer (range/between). Implemented this logic but it does not work for some reason. Would appreciate your help.
I am doing exactly same but my slicer is not disabled. Works when my slicer is dropdown but doesnt work if both my slicers are between.. how can i troubleshoot this please
Disabling a slicer when you know that from calalog stores we do not sell via promotion. How about those scenarios when we are even aware if sell anything via promotion? I am looking at a dynamic hiding whenever there is no selection available on the second slicer.
Unfortunately it doesn't work for me, slicer with dates is still visibile, evertyhing works when slicer is for exmaple dropdown list but when I switch to slicer between it doesn't work, helpppppppppppp
My Power BI does not allow me to select a measure when I do conditional formatting at "Dynamic slicer text" and "Conditional formatting of slicer header" ☹ Edit: Okay it works when I edit the Measures in the Semantic Model😃 and apply the formatting in the Report. I have a live connection to Power BI Service
Looks great, but doesn't work perfectly for me: Once values have been selected in a slicer, they stay visible even when the slicer gets disabled like shown in the video. Anyone else get that problem and/or has a solution?
I really appreciate your videos. Could I make 1 small suggestion though? Could you please put the entire Power BI application in your background and make the video of yourself a little smaller in the corner? I don't know if it's just me but it's so hard to follow which window you're in or which part of Power BI Desktop you're in when all we see is the little window of the part you're working on. We appreciate seeing your face but maybe it'd be okay if it's a little smaller in the corner so we could see more of what's happening. Most of the time, I end up just going to another channel because I don't understand where you are in the application. Thanks again.
This solution was available all along. The problem with this solution is that if any of the options from the slicer to be hidden is either pre-selected or selected during the usage that option will continue to show even when it is not supposed to show. It only works as long as no option is selected from the slicer to be hidden. The moment one option gets selected, the functionality is gone for a toss. Not a realistic solution.
Great illustration, one lingering question: can we filter some of a slicer items (not the whole slicer) based on selection of another slicer? By the way, I found the answer to my question at one of your videos: SMARTER Slicers = BETTER User Experience | Show Only What's Relevant in Your Slicers in Power BI ruclips.net/video/ieySnvM6hVk/видео.html Thank you so much!!
This won't work at all unfortunately, once you have selected the date you can't go back to fiscal year without cleaning all the filters. It's very complicated for the final user.
Awesome idea Bas... The other day someone asked me how to disable a slicer and I told them it is not possible with UI alone. But I am going to point them to this video now :)
This is so hilariously simple, but so useful. I have so many workarounds I've used in the past (like bookmarks) to accomplish this, but never thought about it this way. Love the slicer header trick as well! Thanks so much Bas!
Really great idea to disable the slicer! You can also change color via rules, then you don't need to create a measure and find the specific hex code
thx!
@@HowtoPowerBI Still sad that Microsoft makes us abuse the tool instead of introducing a conditional visibility.
Hi Bas / @HowtoPowerBI
Thanks for the detailed video. I have implemented similar solutions in the past. However, with my solution, the slicers conflicted and returned incorrect results when the Period slicer is disabled and the date range slicer is selected (for example, the last 3 months from January to March). After this, when L12M is selected, it retains filters from both the Date Range slicer and the Period slicer, showing only the last 3 months.
How does the behavior in your implementation differ? Could you please clarify?
Thanks a lot for this and all other videos.
Much appreciated.
Great video. Do you have a video on how to create L12M, 6M period measures. A link would be much appreciated
Measure =
VAR SelectedMode = SELECTEDVALUE( Period )
VAR MonthLag = SWITCH( TRUE(),
SelectedMode = "Last 3 Month" , -3,
SelectedMode = "Last 6 Month" , -6,
SelectedMode = "Last 12 Month" , -12,
0)
RETURN CALCULATE( [Some Measure], DATESBETWEEN('Date'[Date], TODAY() + MonthLag*30, TODAY()) )
Hi Bas, good one again. Many thanks - I succesfully implemented it into my reports. One isue is that when a selection is made in the second slicer when active, the selection in the second slicer remains in place when moving to a disabling category in slicer 1. I have tried to find a way out of that but so far unsuccesfull. Any sugestion for solutions for this from your end?
Yes, similar issue happened for me as well...when 2nd Date Range is enabled and is date is selected and after that return to slicer 1 and selects any value...2nd slicer selection remains....any solution/ideas will be much appreciated. Thank you.
Hello sir, thank you for this video and idea ! Works perfect with these two types of slicers, but i m working on project right now where i use dropdown slicers and it actaully makes a difference, but im still able to "open" dropdown slicer but i see nothing there using your method, which works fine but is it somehow possible to disable dropdown slicer the same way how you did that with date slicer ?
My last question is, is this possible with buttons aswell ? tu use measures to disable and enable buttons in powerBI ?
Thanks for your contet and have nice day !
Thank you. Very useful.
I am a beginner and although I have already created several reports I have always wondered how exactly to do this
Very well explained
Cheers from Barcelona
Thanks mate. There is some issue with slicer of style 'Between'. We cannot disable and enable based on selected values of another slicer.
We are using this and have a Custom option in the date period selector, this will make things a lot neater. The one thing we have not gotten right is resetting the date slider when flipping between date periods.nneed to hit the eraser and then the period, given the text bit I think it will still affect this, likely this will help others who use this, unless this works without that
Great video!
Just one thing, if we have a selection in promotion slicer and than we select cataloge store, it will not deselect the selection in promotion slicer, right? How to handle it?
Great... Thank you for sharing this content. Question here, what if I want to enable/disable a button or image after a slicer is selected any option?
Nice techniques for UX. However, dont you think if we have multiple slicers with such functionality & also several visuals with similar UX techniques which invlove creation of custom measure/columns / buttons / bookmarks / interactions, etc would make the report more complex to manage when someone would want to make changes to report after few months or if report is handed over to a different developer to enhance or maintain ? Thanks
Sure, you can also go for a mediocre report that everyone understands how to build all features .. depends what is more important to you
great video i have implemented same kind of logic in my recent development ..
but changing the colour and text of visual is the cherry on cake ..
will be implementing the same as well.. thank you
Thanks for this video. Your explanation makes it seem so simple, and will be very useful. Paul
Thank, this is really nice. But is there a way to also automatically apply deselection on the slicer which is being disabled ? In this solution, the selection which was made in the first slicer, still remains active, even after that slicer was disabled, by making a selection in the second one. This can result in the wrong number being shown (for example 6M period will be partially filtered by other selection in the disabled date slicer, which would not be expected by the user)?
For date slicer I am using bookmark to show one slicer at a time. But this looks interesting.
That is one way to go. However, bookmarks scale multiplicative. Let's assume that you have 4 bookmarks. If you add some another factor, which needs 2 more Bookmarks for different states (like 2 different chart types or showing/hiding side panel for ex), you will end up creating 2x4 = 8 bookmarks. And that gets increasingly out of control very fast.
Hi Bas glad to watch ur awesome new videos again, just a question please. Inside your report you have a measure used as a filter that is the "Customer Period Filter", inside there you have this VAR:
VAR _MinDate = EOMONTH( _MaxDate , _MoveMonths ) + 1
Can you please explain me what the +1 refers to?
Thanks in advance
Hi, thank you very much for the solution......now a question, as you left your date filter with those bars at the bottom, mine only shows those circles haha.......I'm referring to the date range dates.
try to turn off responsivnes of the slicer in the advance options of Format :)
Bas, thanks for the trick!
Is the line chart continuous or categorical?
I can see it is a time series on X-axis which generally is plotted on a continuous line chart. But you have breaks in the line chart which is not possible in Power BI (unlike Tableau) ... This is required especially for sensor data where the sensor value is missing for certain date-time values.
Simple and powerfull. Amazing, I'm using right now !!!
simple yet very effective use case, great video :)
Once again a very informative and clear video! 👌💪👏
Correct me if I'm wrong but on Excel slicers it's a native feature to hide value with no data. Weird it's not native on PowerBI ?
This is really smart!
I thought it was going to solve my issue, but it's just off. I have 2 slicers that I'm experiencing this problem with but they're both referencing the same field.
The reason is they wanted a quick date slicer to choose custom number of weeks and such but also want to be able to easily toggle custom date ranges(with the between type of slicer), so this solution doesn't work. From the comments, I may try an old school bookmark though
is there a way for you to duplicate this field but name differently? I think you can reuse the described above approach but you just need to separate the fields by creating the second one as a date table
Disabling the slicer does not clear the previously selected values in it. So if you were to filter on date range, and then select a period, the filtered date range values are still in effect, and therefore the selected period could falsely represent the amounts. Is there a way to make the "disabled" slicer go back to default or be cleared, when the other slicer it depends on is being filtered?
Not making it with bookmarks since that kind of defeats the purpose
I tried this method and it works great on the desktop but when I publish to the service the date slicer still allows the user to click on the date to select a date, it just doesn’t actually filter anything. Was very confusing for the users
Bravoooooo Bas...!!! Always great ideas and inspiration.
Many thanks ❤
Thank you! Cheers!
Can you do this with the same date table. I need to show or hide date (Relative) and date (Between) and clear selection after toggle.
That’s really useful. What will happen if two or more values selected in the Period slicer? And can we make it dynamic for the promotion slicer if it does not exist for the selected Store?
you would need to set that slicer to single select only
it is dynamic
You could also add your periods and a "custom" option with forced selection, only downside here is the user needs to click the eraser on the slider when switching to a fixed period
As always phenomenal, thanks bas !!
Is there any way to disable 3rd value selection in a same slicer because i want to restrict user to select only two state at a time if user try to select third value from same slicer slicer gets disable
Can it be true there is no file to download? i cant find it on the page after clicking on the link. I did try type in my information. I couldnt sign in either, it said "registration has been disabled"
Can we use selected value for disabling time range
Great videos, I'll implement this technique soon.
🎉 That's exactly what i needed in my report
Nice trick again! Very insightful 😊
Amazing as always! Thank you!
I can’t find this pbix file to download? Is that an error?
I have a similar setup but with a Year slicer and a Date slicer (range/between). Implemented this logic but it does not work for some reason. Would appreciate your help.
Maybe check the download file and see what you did differently
I am doing exactly same but my slicer is not disabled. Works when my slicer is dropdown but doesnt work if both my slicers are between.. how can i troubleshoot this please
keep going Bas, we love you
How do I reset the date slicer before disabling?
Truly useful. Bookmarked!
If the slicer changes the date and back to click L6M the date is not disable how to do
How about single selection? :)
Disabling a slicer when you know that from calalog stores we do not sell via promotion. How about those scenarios when we are even aware if sell anything via promotion? I am looking at a dynamic hiding whenever there is no selection available on the second slicer.
try to use single column tables instead of slicers
Unfortunately it doesn't work for me, slicer with dates is still visibile, evertyhing works when slicer is for exmaple dropdown list but when I switch to slicer between it doesn't work, helpppppppppppp
My Power BI does not allow me to select a measure when I do conditional formatting at "Dynamic slicer text" and "Conditional formatting of slicer header" ☹
Edit: Okay it works when I edit the Measures in the Semantic Model😃 and apply the formatting in the Report. I have a live connection to Power BI Service
As always amazing
how to exclude a visual from page level filter in power bi?
You can’t. You would need to work then with the visual level filters
Morning dear, how I can showing the group "matrics" on the right panel like I saw in your vedio?
Just create a new table in the modeling view with no content or one column. Rename that and done.
ruclips.net/video/cGnWPua-cmo/видео.html
Unfortunately, this does not seem to work with Relative Date and Relative Time type of slicers
Brilliant. Thx for sharing.
Amazing great New learning in Power BI
Glad you think so!
What about hiding it instead of disabling?
A very basic feature that's still missing unfortunately
that would be nice
Something Qlikview had 13 years ago that PBI for some reason can’t do.
Agreed.. Hiding or changing layer value to bring forward or back. But this is good progress in capabilities.
Thank you sir 😊
Looks great, but doesn't work perfectly for me: Once values have been selected in a slicer, they stay visible even when the slicer gets disabled like shown in the video. Anyone else get that problem and/or has a solution?
You are a beast!
It's ridiculous the number of "hacks" you need to do in order for power bi to work properly
Friendly Suggestion No thumbnail ✋ Maybe You forgot to choose ...
Make it fix✅❤️
oops
Two Power BI Legend in one Frame❤😍
Great tips many thanks
😁thx
TOP! Thanks!
THANKS! 😁
You are awesome
beyond godlike
😁 thx!
Thank's 👏☺️
You're welcome 😊
I really appreciate your videos. Could I make 1 small suggestion though? Could you please put the entire Power BI application in your background and make the video of yourself a little smaller in the corner? I don't know if it's just me but it's so hard to follow which window you're in or which part of Power BI Desktop you're in when all we see is the little window of the part you're working on. We appreciate seeing your face but maybe it'd be okay if it's a little smaller in the corner so we could see more of what's happening. Most of the time, I end up just going to another channel because I don't understand where you are in the application. Thanks again.
thanks for the feedback. I prefer the editing style as is, so probably wont change any time soon
This solution was available all along. The problem with this solution is that if any of the options from the slicer to be hidden is either pre-selected or selected during the usage that option will continue to show even when it is not supposed to show. It only works as long as no option is selected from the slicer to be hidden. The moment one option gets selected, the functionality is gone for a toss. Not a realistic solution.
Perfect
Great illustration,
one lingering question: can we filter some of a slicer items (not the whole slicer) based on selection of another slicer?
By the way, I found the answer to my question at one of your videos:
SMARTER Slicers = BETTER User Experience | Show Only What's Relevant in Your Slicers in Power BI
ruclips.net/video/ieySnvM6hVk/видео.html
Thank you so much!!
This won't work at all unfortunately, once you have selected the date you can't go back to fiscal year without cleaning all the filters. It's very complicated for the final user.
why do you always look like you would benefit from more sleep? please address your health, we do rely on you and would like to see you around.
That's a really distasteful comment to make
Absolute rubbish comment to make.
Awesome, got to use this in my dashboard
💻🤓😁 hope you got it up and running