Dynamically Enable and Disable Slicers in Power BI

Рет қаралды 21,903

Күн бұрын

Join my Power BI Design training here: my.datatraining.io/pages/powe...
Enjoy and subscribe to always stay updated on my favorite Power BI tricks :)
Download file here datatraining.io/powerbi-how-to
--------------------------------
📊 TRAININGS 📊
---------------------------------
Power BI Design 4 Weeks Transformation Program my.datatraining.io/pages/powe...
Power BI Essentials datatraining.io/powerbilearni...
Business User Training datatraining.io/powerbi-busin...
For Custom Trainings and Consulting email directly support@datatraining.io
---------------------------------
⏱️ TIMESTAMPS ⏱️
---------------------------------
00:00 Intro
00:44 Visual filter for timeline slicer
03:00 Dynamic slicer text
04:27 Conditional formatting of slicer header
06:00 Text slicers, button slicers
06:43 Slicer interactions
10:36 End
---------------------------------
😍 JOIN 😍
----------------------------------
Join bit.ly/4b453bi
Subscribe bit.ly/31MnQGO
Insta / howtopowerbi
LinkedIn / basdohmen
TikTok / how.to.power.bi
X / howtopowerbi
fb / howtopowerbi
Threads www.threads.net/@howtopowerbi
Newsletter datatraining.io/newsletter
---------------------------------
👇 CHECK THIS OUT! 👇
---------------------------------
💻 My gear amzn.to/47F21Yc
📚 Power BI books MUST READ! amzn.to/3tUfFcj
💡 General books I recommend amzn.to/48YNo33
🎶 Music for my videos www.epidemicsound.com/referra...
🚀 For growing on KZfaq: www.tubebuddy.com/bas
🏄 Stuff I use daily amzn.to/3HqfMQ2
* Above are affiliate links, which means at no additional cost to you, if you make a purchase using these links we will receive a small commission. It supports us and helps us to continue making more How to Power BI videos!
Thanks for being a part of this channel and all your support! 💪 🙏
#HowToPowerBI #PowerBI #DataTraining
#powerbidesktop #powerbitraining #powerbideveloper #DAX

Пікірлер: 83

@SQLDevDBA 29 күн бұрын

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 29 күн бұрын

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 29 күн бұрын

thx!

@alexgry4763 26 күн бұрын

@@HowtoPowerBI Still sad that Microsoft makes us abuse the tool instead of introducing a conditional visibility.

@jabiermartines 21 күн бұрын

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

@worldofdata 28 күн бұрын

simple yet very effective use case, great video :)

@poojadattachoudhury9634 28 күн бұрын

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

@MarcoAntonio-yj4br 29 күн бұрын

Amazing as always! Thank you!

@PaulEBrownbill 24 күн бұрын

Thanks for this video. Your explanation makes it seem so simple, and will be very useful. Paul

@henriquemerolafaria2569 28 күн бұрын

Simple and powerfull. Amazing, I'm using right now !!!

@nizararena 29 күн бұрын

As always phenomenal, thanks bas !!

@cmagnos 28 күн бұрын

Great videos, I'll implement this technique soon.

@fanlovexcel 27 күн бұрын

Nice trick again! Very insightful 😊

@marekbona4987 27 күн бұрын

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 !

@kingslayer1156 29 күн бұрын

Great video. Do you have a video on how to create L12M, 6M period measures. A link would be much appreciated

@alexgry4763 27 күн бұрын

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()) )

@RadAlzyoud 29 күн бұрын

Brilliant. Thx for sharing.

@roverre61 29 күн бұрын

Bravoooooo Bas...!!! Always great ideas and inspiration. Many thanks ❤

@HowtoPowerBI 29 күн бұрын

Thank you! Cheers!

@excel-solutions4564 26 күн бұрын

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?

@paulgeorges2267 28 күн бұрын

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 ?

@QuantumIdeas 25 күн бұрын

Truly useful. Bookmarked!

@mustafabiviji00711 29 күн бұрын

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.

@harshilmarwadi1958 22 күн бұрын

🎉 That's exactly what i needed in my report

@AbhinavPhukan-gd1di 9 күн бұрын

Thanks mate. There is some issue with slicer of style 'Between'. We cannot disable and enable based on selected values of another slicer.

@rafaybahelmi 29 күн бұрын

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.

@Fannie2uN2010 23 күн бұрын

keep going Bas, we love you

@anupamjha827 27 күн бұрын

Can we use selected value for disabling time range

@OlayemiOA 27 күн бұрын

Thank you sir 😊

@leonelalegria7787 18 күн бұрын

TOP! Thanks!

@HowtoPowerBI 17 күн бұрын

THANKS! 😁

@8g8819 28 күн бұрын

You are a beast!

@usman_oz 29 күн бұрын

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 29 күн бұрын

Sure, you can also go for a mediocre report that everyone understands how to build all features .. depends what is more important to you

@johnbaisley2799 26 күн бұрын

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

@ankurgupta4325 10 сағат бұрын

You are awesome

@azwarmzafar 29 күн бұрын

Great tips many thanks

@HowtoPowerBI 29 күн бұрын

😁thx

@AlphaPrime808 29 күн бұрын

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 27 күн бұрын

try to turn off responsivnes of the slicer in the advance options of Format :)

@jainilvora7167 28 күн бұрын

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

@ashishmohan4707 29 күн бұрын

Amazing great New learning in Power BI

@HowtoPowerBI 29 күн бұрын

Glad you think so!

@rahulmaurya9444 29 күн бұрын

For date slicer I am using bookmark to show one slicer at a time. But this looks interesting.

@alexgry4763 27 күн бұрын

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.

@niltonsantos479 29 күн бұрын

Perfect

@nicolajpetersen4673 28 күн бұрын

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"

@CS-cl3ij 27 күн бұрын

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 25 күн бұрын

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

@DineshKumar-rf9eh 29 күн бұрын

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 29 күн бұрын

you would need to set that slicer to single select only

@HowtoPowerBI 29 күн бұрын

it is dynamic

@MrSparkefrostie 29 күн бұрын

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

@MrSparkefrostie 29 күн бұрын

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

@nevermore17011990 19 күн бұрын

beyond godlike

@HowtoPowerBI 19 күн бұрын

😁 thx!

@The-Developer-BI 29 күн бұрын

Friendly Suggestion No thumbnail ✋ Maybe You forgot to choose ... Make it fix✅❤️

@HowtoPowerBI 29 күн бұрын

oops

@user-bl4ux7bg9k 29 күн бұрын

Two Power BI Legend in one Frame❤😍

@TheAtulsachan1234 23 күн бұрын

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.

@arturpiwowarski7775 26 күн бұрын

How about single selection? :)

@Koikby79 24 күн бұрын

I can’t find this pbix file to download? Is that an error?

@AhmedCherif-mt5lb 29 күн бұрын

Thank's 👏☺️

@HowtoPowerBI 29 күн бұрын

You're welcome 😊

@MrHaddad 29 күн бұрын

Morning dear, how I can showing the group "matrics" on the right panel like I saw in your vedio?

@benndii 29 күн бұрын

Just create a new table in the modeling view with no content or one column. Rename that and done.

@HowtoPowerBI 29 күн бұрын

kzfaq.info/get/bejne/ma2eirOmxpPHnaM.html

@Art_Van_Delay 18 күн бұрын

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 18 күн бұрын

thanks for the feedback. I prefer the editing style as is, so probably wont change any time soon

@IvanKashperuk 29 күн бұрын

What about hiding it instead of disabling?

@LucaGanugi 29 күн бұрын

A very basic feature that's still missing unfortunately

@HowtoPowerBI 29 күн бұрын

that would be nice

@mcnater 29 күн бұрын

Something Qlikview had 13 years ago that PBI for some reason can’t do.

@JamesBatchelorGoogleProfile 28 күн бұрын

Agreed.. Hiding or changing layer value to bring forward or back. But this is good progress in capabilities.

@ivanxdxd 29 күн бұрын

It's ridiculous the number of "hacks" you need to do in order for power bi to work properly

@MagdyTawfikA 27 күн бұрын

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 kzfaq.info/get/bejne/n8uphtGnspzMhp8.html Thank you so much!!