Non-Sticky Slicer Trick in Power BI

Подписаться 89 тыс.

Просмотров 9 тыс.

50% 1

Matt Allington's Blog 🌐 - exceleratorbi.com.au/slicer-v...
Let me teach you DAX & Data Modeling in Power BI in the most simple and effective way. 📊 - goodly.co.in/learn-dax-powerbi/
In this video, you will learn how to unselect slicers automatically in Power BI, making your data analysis more intuitive and efficient. The default behavior of slicers can often be confusing, but with the techniques shared in this tutorial, you will be able to reset sticky slicers and achieve a more user-friendly experience in your Power BI dashboard.
===== ONLINE COURSES =====
✔️ Mastering DAX in Power BI -
goodly.co.in/learn-dax-powerbi/
✔️ Power Query Course-
goodly.co.in/learn-power-query/
✔️ Master Excel Step by Step-
goodly.co.in/learn-excel/
✔️ Business Intelligence Dashboards-
goodly.co.in/learn-excel-dash...
===== LINKS 🔗 =====
Blog 📰 - www.goodly.co.in/blog/
Corporate Training 👨‍🏫 - www.goodly.co.in/training/
Need my help on a Project 💻- www.goodly.co.in/consulting/
Download File ⬇️ - goodly.co.in/non-sticky-slice...
===== CONTACT 🌐 =====
Twitter - / chandeep2786
LinkedIn - / chandeepchhabra
Email - goodly.wordpress@gmail.com
===== CHAPTERS =====
00:00 The Problem with default behavior of Slicers in Power BI
01:23 Slicer Behavior
02:23 Example of an Ideal Slicer
03:24 The Logic and the Process
07:14 Creating the Helper Table
10:51 Final Solution
===== 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!

Наука

Опубликовано:

26 июн 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 41

@sharmarudra 2 месяца назад

Wow!! Never knew that field parameters can show the field values also. With this you have solved my problem. Thank you, Chandeep.

@saadiquemerchant Месяц назад

This is a great video workflow, especially the problem section at the start

@GoodlyChandeep 2 месяца назад

Matt Allington's Blog 🌐 - exceleratorbi.com.au/slicer-values-dont-clear-after-changing-a-second-slicer/ Download the Power BI file ⬇ - goodly.co.in/non-sticky-slicer-trick-power-bi Let me teach you DAX & Data Modeling in Power BI in the most simple and effective way. 📊 - goodly.co.in/learn-dax-powerbi/

@williamthedataprof 2 месяца назад

This is out of this world! Will give it a shot

@user-bg7tw8xo7e 2 месяца назад

I was looking for this solution last week... With this trick you have solved my problem

@HachiAdachi 2 месяца назад

🤯 DAAAAMMMNNNN!!! Well done, Chandeep! 👍 Thank you for the EPIC solution for this annoying quirk! 😊 Gotta update all of my reports with paired slicers now...

@pondyanand 2 месяца назад

Brilliant !! Thanks much.

@Nikol_YouTube 2 месяца назад

Beautiful work once again Chandeep! Thank you :)

@dilipinamdar5523 2 месяца назад

Awesome !!!! Thankyou🙏

@user-kx1gr2dw7c 2 месяца назад

Amazing solution

@prakashvishwakarma7933 2 месяца назад

This is really awesome ❤

@agustinrajan8621 2 месяца назад

Superb solution ❤

@manojkahar5718 2 месяца назад

Great video again, thank you Chandu

@unnikrishnansanthosh 2 месяца назад

great one sir, keep it up

@chrism9037 2 месяца назад

Another great one Chandeep!

@GoodlyChandeep 2 месяца назад

Thanks Chris 😄

@barttitulaerexcelbart9400 Месяц назад

Thank you very much! especially field parameters: show values. hot tip! But... since I am not that good at writing M, I tried to make this helper table with the GUI. It did work but it was sometimes hard coded. Tihs is how I did this: I made two queries: one unique products, one unique brands. Then I merged them (cross join). Then I added an index column and a MOD collumn to get numbers from 0 to 11. Then pivot and don't aggegate. This is easier but your solution is dynamic, as it should be..😉

@zahir585 2 месяца назад

Helper query ❤ love this terminology I’ve been using it for awhile but was not sure how to call this lol anyhow brilliant that you my friend

@GoodlyChandeep 2 месяца назад

😁

@RogerStocker 2 месяца назад

Really dammed awesome! I can't say it different.

@eliasNoTears 2 месяца назад

Awesome 😍

@Zamanna 2 месяца назад

Very interesting one.. 👍

@AnilKumar-vi8oe 2 месяца назад

Great again

@toulasantha Месяц назад

Interesting. Haven’t looked into this in depth. Would the pivot or unpivot of the dimension table be a quicker option ?

@edwindeo 2 месяца назад

More like pretty dam Brilliant.

@frederikgoerlandt 2 месяца назад

Genius ❤

@ExcelPro. 2 месяца назад

Awesome 💯 i want to lean it... In cases you provide online training 😮😊

@koblamensah8900 2 месяца назад

Chandeep, thanks for the useful information you provide on your channel. I have learnt a lot from you. If I should create the table for the Field Parameter slicer in Excel, for instance, and create the relationships between the tables as you did after creating the slicers, will it work the same way?

@Nalaka-Wanniarachchi 2 месяца назад

Another interesting one as always,Not to miss the time 6 PM IST.😀

@GoodlyChandeep 2 месяца назад

😉

@guppi1 2 месяца назад

Yes, it is pretty damn awesome

@ai_learner_cat Месяц назад

I have an error in Band measure : The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value.

@pthapa55 2 месяца назад

That is amazing tricks. When you created helper table, can't we do unpivoting directly or that will not work?

@jatinsrivastava6061 2 месяца назад

It helped to resolve one of my Issues, Thanks for that. I have one query, lets say I have Same Products in the different bands then one 2 one Relationship will not work. I know according to your example it's a stupid question 😂.

@MrSparkefrostie Месяц назад

Seems any question in PBI had the same answer, fields parameters

@rohitsharma-hz2sf 2 месяца назад

Please create video for power query most asked interview questions

@zorankrekic3006 2 месяца назад

Nice again, but table Bands is created from parameter, what if we get more rows in table helper, then should manually add in table bands, or is it possible get dynamically

@MalinaC Месяц назад

👍👍👍

@TazmanianFlo 2 месяца назад

great solution for this case. however i think it will not work efficiently (if at all), if you have a lot of data. like thousands of projects in slicer A and in slicer B all of the tasks of these projects. Maybe I'll give it a try though