Dynamically Enable and Disable Slicers in Power BI
HTML-код
- Опубликовано: 31 май 2024
- 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 RUclips: 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 - Наука
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.
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
simple yet very effective use case, great video :)
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
Amazing as always! Thank you!
Simple and powerfull. Amazing, I'm using right now !!!
Great videos, I'll implement this technique soon.
As always phenomenal, thanks bas !!
Nice trick again! Very insightful 😊
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 !
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()) )
Brilliant. Thx for sharing.
Bravoooooo Bas...!!! Always great ideas and inspiration.
Many thanks ❤
Thank you! Cheers!
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 ?
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?
Truly useful. Bookmarked!
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.
🎉 That's exactly what i needed in my report
Thanks mate. There is some issue with slicer of style 'Between'. We cannot disable and enable based on selected values of another slicer.
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.
keep going Bas, we love you
TOP! Thanks!
THANKS! 😁
Thank you sir 😊
Can we use selected value for disabling time range
You are a beast!
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
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
Great tips many thanks
😁thx
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 :)
Amazing great New learning in Power BI
Glad you think so!
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
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.
Perfect
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"
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
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
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
beyond godlike
😁 thx!
Friendly Suggestion No thumbnail ✋ Maybe You forgot to choose ...
Make it fix✅❤️
oops
Two Power BI Legend in one Frame❤😍
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.
How about single selection? :)
I can’t find this pbix file to download? Is that an error?
Thank's 👏☺️
You're welcome 😊
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
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
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.
It's ridiculous the number of "hacks" you need to do in order for power bi to work properly
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!!
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