Dynamically Enable and Disable Slicers in Power BI

  Рет қаралды 31,133

How to Power BI

How to Power BI

Күн бұрын

Пікірлер: 97
@SQLDevDBA
@SQLDevDBA 4 ай бұрын
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!
@ereg31415
@ereg31415 4 ай бұрын
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
@HowtoPowerBI
@HowtoPowerBI 4 ай бұрын
thx!
@alexgry4763
@alexgry4763 4 ай бұрын
@@HowtoPowerBI Still sad that Microsoft makes us abuse the tool instead of introducing a conditional visibility.
@MrSparkefrostie
@MrSparkefrostie 4 ай бұрын
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
@kingslayer1156
@kingslayer1156 4 ай бұрын
Great video. Do you have a video on how to create L12M, 6M period measures. A link would be much appreciated
@alexgry4763
@alexgry4763 4 ай бұрын
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()) )
@jabiermartines
@jabiermartines 4 ай бұрын
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
@rafaybahelmi
@rafaybahelmi 4 ай бұрын
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.
@poojadattachoudhury
@poojadattachoudhury 4 ай бұрын
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
@PaulEBrownbill
@PaulEBrownbill 4 ай бұрын
Thanks for this video. Your explanation makes it seem so simple, and will be very useful. Paul
@CS-cl3ij
@CS-cl3ij 4 ай бұрын
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
@LeonidKostin
@LeonidKostin 4 ай бұрын
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
@AbhinavPhukan-gd1di
@AbhinavPhukan-gd1di 3 ай бұрын
Thanks mate. There is some issue with slicer of style 'Between'. We cannot disable and enable based on selected values of another slicer.
@MrPloinky
@MrPloinky 23 күн бұрын
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?
@usman_oz
@usman_oz 4 ай бұрын
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
@HowtoPowerBI
@HowtoPowerBI 4 ай бұрын
Sure, you can also go for a mediocre report that everyone understands how to build all features .. depends what is more important to you
@excel-solutions4564
@excel-solutions4564 4 ай бұрын
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?
@henriquemerolafaria2569
@henriquemerolafaria2569 4 ай бұрын
Simple and powerfull. Amazing, I'm using right now !!!
@marekbona4987
@marekbona4987 4 ай бұрын
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 !
@juanignacioXI
@juanignacioXI 27 күн бұрын
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
@mariuszkrzemien6576
@mariuszkrzemien6576 Ай бұрын
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
@stefankleinhans4895
@stefankleinhans4895 2 ай бұрын
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.
@The-Developer-BI
@The-Developer-BI 4 ай бұрын
Friendly Suggestion No thumbnail ✋ Maybe You forgot to choose ... Make it fix✅❤️
@HowtoPowerBI
@HowtoPowerBI 4 ай бұрын
oops
@AyanKhan-d6f8v
@AyanKhan-d6f8v 4 ай бұрын
Two Power BI Legend in one Frame❤😍
@worldofdata
@worldofdata 4 ай бұрын
simple yet very effective use case, great video :)
@roverre61
@roverre61 4 ай бұрын
Bravoooooo Bas...!!! Always great ideas and inspiration. Many thanks ❤
@HowtoPowerBI
@HowtoPowerBI 4 ай бұрын
Thank you! Cheers!
@harshilmarwadi1958
@harshilmarwadi1958 4 ай бұрын
🎉 That's exactly what i needed in my report
@johnbaisley2799
@johnbaisley2799 4 ай бұрын
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
@AnishShrestha-u3o
@AnishShrestha-u3o 3 күн бұрын
How do I reset the date slicer before disabling?
@gettingby987
@gettingby987 2 күн бұрын
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?
@gettingby987
@gettingby987 2 күн бұрын
Not making it with bookmarks since that kind of defeats the purpose
@rahulmaurya9444
@rahulmaurya9444 4 ай бұрын
For date slicer I am using bookmark to show one slicer at a time. But this looks interesting.
@alexgry4763
@alexgry4763 4 ай бұрын
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.
@nizar_arena
@nizar_arena 4 ай бұрын
As always phenomenal, thanks bas !!
@cmagnos
@cmagnos 4 ай бұрын
Great videos, I'll implement this technique soon.
@MarcoAntonio-yj4br
@MarcoAntonio-yj4br 4 ай бұрын
Amazing as always! Thank you!
@paulgeorges2267
@paulgeorges2267 4 ай бұрын
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 ?
@dmitrypopok
@dmitrypopok 3 ай бұрын
Unfortunately, this does not seem to work with Relative Date and Relative Time type of slicers
@fanlovexcel
@fanlovexcel 4 ай бұрын
Nice trick again! Very insightful 😊
@QuantumIdeas
@QuantumIdeas 4 ай бұрын
Truly useful. Bookmarked!
@Fannie2uN2010
@Fannie2uN2010 4 ай бұрын
keep going Bas, we love you
@Harika2775
@Harika2775 2 ай бұрын
If the slicer changes the date and back to click L6M the date is not disable how to do
@borteyhumphrey
@borteyhumphrey 3 ай бұрын
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.
@HowtoPowerBI
@HowtoPowerBI 3 ай бұрын
Maybe check the download file and see what you did differently
@Art_Van_Delay
@Art_Van_Delay 4 ай бұрын
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.
@HowtoPowerBI
@HowtoPowerBI 4 ай бұрын
thanks for the feedback. I prefer the editing style as is, so probably wont change any time soon
@anupamjha827
@anupamjha827 4 ай бұрын
Can we use selected value for disabling time range
@mustafabiviji00711
@mustafabiviji00711 4 ай бұрын
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.
@nicolajpetersen4673
@nicolajpetersen4673 4 ай бұрын
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"
@down_with_data
@down_with_data 3 ай бұрын
As always amazing
@RadAlzyoud
@RadAlzyoud 4 ай бұрын
Brilliant. Thx for sharing.
@DineshKumar-rf9eh
@DineshKumar-rf9eh 4 ай бұрын
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?
@HowtoPowerBI
@HowtoPowerBI 4 ай бұрын
you would need to set that slicer to single select only
@HowtoPowerBI
@HowtoPowerBI 4 ай бұрын
it is dynamic
@MrSparkefrostie
@MrSparkefrostie 4 ай бұрын
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
@AlphaPrime808
@AlphaPrime808 4 ай бұрын
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.
@yuliiakamkova7022
@yuliiakamkova7022 4 ай бұрын
try to turn off responsivnes of the slicer in the advance options of Format :)
@jainilvora7167
@jainilvora7167 4 ай бұрын
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
@arturpiwowarski7775
@arturpiwowarski7775 4 ай бұрын
How about single selection? :)
@ashishmohan4707
@ashishmohan4707 4 ай бұрын
Amazing great New learning in Power BI
@HowtoPowerBI
@HowtoPowerBI 4 ай бұрын
Glad you think so!
@OOA_BI
@OOA_BI 4 ай бұрын
Thank you sir 😊
@TheAtulsachan1234
@TheAtulsachan1234 4 ай бұрын
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.
@sanchowitfurrows1561
@sanchowitfurrows1561 2 ай бұрын
try to use single column tables instead of slicers
@ankurgupta4325
@ankurgupta4325 3 ай бұрын
You are awesome
@8g8819
@8g8819 4 ай бұрын
You are a beast!
@leonelalegria7787
@leonelalegria7787 4 ай бұрын
TOP! Thanks!
@HowtoPowerBI
@HowtoPowerBI 4 ай бұрын
THANKS! 😁
@azwarmzafar
@azwarmzafar 4 ай бұрын
Great tips many thanks
@HowtoPowerBI
@HowtoPowerBI 4 ай бұрын
😁thx
@iiiiii-w8h
@iiiiii-w8h 4 ай бұрын
It's ridiculous the number of "hacks" you need to do in order for power bi to work properly
@nevermore17011990
@nevermore17011990 4 ай бұрын
beyond godlike
@HowtoPowerBI
@HowtoPowerBI 4 ай бұрын
😁 thx!
@avishekghosh8134
@avishekghosh8134 23 күн бұрын
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.
@Koikby79
@Koikby79 4 ай бұрын
I can’t find this pbix file to download? Is that an error?
@niltonsantos479
@niltonsantos479 4 ай бұрын
Perfect
@MrHaddad
@MrHaddad 4 ай бұрын
Morning dear, how I can showing the group "matrics" on the right panel like I saw in your vedio?
@benndii
@benndii 4 ай бұрын
Just create a new table in the modeling view with no content or one column. Rename that and done.
@HowtoPowerBI
@HowtoPowerBI 4 ай бұрын
kzbin.info/www/bejne/mXjRiIOrlpKWo9E
@AhmedCherif-mt5lb
@AhmedCherif-mt5lb 4 ай бұрын
Thank's 👏☺️
@HowtoPowerBI
@HowtoPowerBI 4 ай бұрын
You're welcome 😊
@IvanKashperuk
@IvanKashperuk 4 ай бұрын
What about hiding it instead of disabling?
@LucaGanugi
@LucaGanugi 4 ай бұрын
A very basic feature that's still missing unfortunately
@HowtoPowerBI
@HowtoPowerBI 4 ай бұрын
that would be nice
@mcnater
@mcnater 4 ай бұрын
Something Qlikview had 13 years ago that PBI for some reason can’t do.
@JamesBatchelorGoogleProfile
@JamesBatchelorGoogleProfile 4 ай бұрын
Agreed.. Hiding or changing layer value to bring forward or back. But this is good progress in capabilities.
@MagdyTawfikA
@MagdyTawfikA 4 ай бұрын
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 kzbin.info/www/bejne/n5bchKGsgpubjM0 Thank you so much!!
@mariamolchanova3831
@mariamolchanova3831 4 ай бұрын
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.
@sum_andres31
@sum_andres31 4 ай бұрын
That's a really distasteful comment to make
@theoldvocals266
@theoldvocals266 4 ай бұрын
Absolute rubbish comment to make.
@edwinarchico439
@edwinarchico439 4 ай бұрын
Awesome, got to use this in my dashboard
@HowtoPowerBI
@HowtoPowerBI 4 ай бұрын
💻🤓😁 hope you got it up and running
Power BI Themes with CUSTOM ICONS 🚀 ❤️
21:29
How to Power BI
Рет қаралды 26 М.
3 Ways to use Calculation Groups You Need to Know
20:00
How to Power BI
Рет қаралды 69 М.
when you have plan B 😂
00:11
Andrey Grechka
Рет қаралды 62 МЛН
How Strong is Tin Foil? 💪
00:26
Preston
Рет қаралды 75 МЛН
Как подписать? 😂 #shorts
00:10
Денис Кукояка
Рет қаралды 6 МЛН
Пришёл к другу на ночёвку 😂
01:00
Cadrol&Fatich
Рет қаралды 10 МЛН
Top 10 Power BI Features You Should Be Using Right Now!
17:24
How to Power BI
Рет қаралды 48 М.
5 Design Mistakes to Avoid in Power BI
11:35
How to Power BI
Рет қаралды 83 М.
My 3 SECRETS for Power BI Parameters You MUST TRY!
25:58
How to Power BI
Рет қаралды 28 М.
SIMPLE Technique for Choosing the Ideal Power BI Data Model
8:41
From Zero2BI Hero with Stelian
Рет қаралды 3,1 М.
Build This Vertical Timeline in Power BI!
25:03
How to Power BI
Рет қаралды 41 М.
3 Hacks to Work Faster in Power BI
25:39
How to Power BI
Рет қаралды 65 М.
Upgrade Your REPORT DESIGN in Power BI | Complete Walkthrough From A to Z
33:24
The Best KPI Cards In Power BI
40:17
Power BI Park
Рет қаралды 26 М.
Build a Slicer Panel in Power BI Like a PRO
20:40
Your Own KPI
Рет қаралды 74 М.
when you have plan B 😂
00:11
Andrey Grechka
Рет қаралды 62 МЛН