3 Insanely Awesome Slicer Tricks in Power BI 🤯

In this video, we will learn three incredible Power BI slicer tricks that will take your data visualization to the next level. From setting default selections in slicers to highlighting specific elements in visuals, these tricks will surely boost your Power BI skills.

===== ONLINE COURSES =====
✔️ Master 'M' in Power Query -

✔️ Mastering DAX in Power BI -

✔️ Power Query Course-

✔️ Master Excel Step by Step-

✔️ Business Intelligence Dashboards-

===== LINKS 🔗 =====

===== CONTACT 🌐 =====

===== WHO AM I? =====
A lot of people think that my name is Goodly, it's NOT ;)
My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.
Please browse around, you'd find a ton of interesting videos that I have created :) Cheers!

[Lyriks_]

IMO Chandeep is one of the few excel professionnal that is really fluent in DAX, M and excel language.. MVP in the making 🚀

[namangarg]

Second solution was very good to know in an easy manner..first was done in recent project of mine..tks goodly ji

[TheKuruamparambatta]

Loved the hierarchical Will definitely use that in grouping the measures in future projects 👍🙏

[IvanCortinas_ES]

Tremendous tutorial. Very good. Thanks Chandeep.

[samirmurali]

I am addicted to all your videos, your method of presentation and the content is like " too good". Vahe Guru

[Arkronis]

The hierarchical method to switch on messures is absolutely game changing for what i am working on right now. Cant wait to implement it :)

[mishymoo]

Awesome! Will be looking for ways to apply these tricks!

[AnilKumar-vioe]

You are a absolute master man, awesome as always

[rauljimenez]

Thank you very much for always sharing your knowledge.

There is an issue with the highlighting. When there is nothing chosen in the disconnected slicer all the rows will get highlighted. To get arround that you can add another condition to the if => IF ( countrows >= 1 & ISFILTERED ('Product Disconnected'[Product]), .... The ISFILTERED only lets the condition be true if there is something chosen in the slicer.

[laurentmarc]

Great videos, as always !-) Happy to see that I'm using constantly the tricks 1 and 3, and knew a bit the trick 2 also. At the end many things from videos stay in my head 🙂

[gennarocimmino]

a big, big, big THANKS for shared tutorial :)

[eqhumxb]

Awersome. It's really nice tutorial. It's helped my today on my work )

[emmanuelapalowo]

The first trick is a game-changer for me. I had to get a custom slicer to be able to achieve having the current month selected on my date slicer in my previous dashboards

[akshaymagre]

Mind Blowing Chandeep. . Awesome mann 🤩

[kwanhangcheung]

Hi, it is very nice n very good video.
Thx very much

[raymondmcgaw]

Awesome video, I have done something similar with the current month, by creating offset columns in my calendar (month, week, day, etc.) and another column that says if Month Offset = 0, then "Current" (<0 then previous...). I use this in a hierarchy and similarly, just have Current Month selected, very handy for reports.

[Rajkumar-kjvx]

Thanks for the video, learnt something new as always. like the first trick, how max date wrt refresh date can be shown in the slicer if the slicer is of type "BETWEEN"?

[brightonalbert]

You always have what I am looking for, what if I am looking for the previous quarters data as default. So how do I go about that.

[kuldippandey]

@goodly how can we sort the values in slicer - custom order

[mohdzohairrizvi]

can we not use edit interaction to highlight the bars by selecting the unique dimension value and highlighting the fact values in the fact table ?