Dynamically Enable and Disable Slicers in Power BI

Enjoy and subscribe to always stay updated on my favorite Power BI tricks :)

--------------------------------
📊 TRAININGS 📊
---------------------------------

---------------------------------
⏱️ 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 😍
----------------------------------

---------------------------------
👇 CHECK THIS OUT! 👇
---------------------------------

* 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

[SQLDevDBA]

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!

[ereg]

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

[PaulEBrownbill]

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

[worldofdata]

simple yet very effective use case, great video :)

[jabiermartines]

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

[henriquemerolafaria]

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

[cmagnos]

Great videos, I'll implement this technique soon.

[poojadattachoudhury]

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

[roverre]

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

[harshilmarwadi]

🎉 That's exactly what i needed in my report

[MrSparkefrostie]

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

[paulgeorges]

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 ?

[marekbona]

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 !

[ashishmohan]

Amazing great New learning in Power BI

[excel-solutions]

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?

[kingslayer]

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

[rafaybahelmi]

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.

[The-Developer-BI]

Friendly Suggestion No thumbnail ✋ Maybe You forgot to choose ...

Make it fix✅❤️

[mustafabiviji]

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.

[rahulmaurya]

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