3 Insanely Awesome Slicer Tricks in Power BI 🤯

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

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

50% 1

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.
📨Subscribe to my Email Newsletter - goodly.co.in/subscribe/
===== ONLINE COURSES =====
✔️ Master 'M' in Power Query -
goodly.co.in/learn-m-powerquery/
✔️ 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/3-awesome-slicer...
===== CONTACT 🌐 =====
Twitter - / chandeep2786
LinkedIn - / chandeepchhabra
Email - goodly.wordpress@gmail.com
===== 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!

Наука

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

20 июн 2024

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

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

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

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

⬇ Download the file - goodly.co.in/3-awesome-slicer-tricks-power-bi 📌Also, check out my awesome courses on DAX & Data Modeling - goodly.co.in/learn-dax-powerbi/

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

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

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

Awesome 🤩! Thank you for the video!

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

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

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

Awesome tricks. Thank you.

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

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

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

Tremendous tutorial. Very good. Thanks Chandeep.

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

So awesome, thanks Chandeep!

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

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

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

You just never stop to amaze me!!!

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

You are a absolute master man, awesome as always

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

Great tricks!

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

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

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

Great.

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

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

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

Love you Bro, You are just awesome ❤

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

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

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

Awesome video sir

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

you are amazing !.

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

Thx… 2. tip I will use

@josealvesferreira1683 16 дней назад

Very good

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

So good 🎉

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

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 🙂

@Rajkumar-kj1vx Месяц назад

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"?

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

very interesting 🤩🤩

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

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

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

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.

@mohdzohairrizvi4377 21 день назад

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 ?

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

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

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

👌 ❤❤

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

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.

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

Thanks for improvising

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

Mind Blowing Chandeep. . Awesome mann 🤩

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

Thanks Akshay :)

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

Guru Bosss

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

Thank you for sharing amazing trick. Will the slicer default selection work dynamically only when we write text as "Green color check box followed Current Month text" or can we put any text in the condition? because same type of scenario I tried to implement by inserting same conditional columns and default text. But finally I couldn't make it possible with this approach and had to go with bookmarks. Kindly confirm and suggest.

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

❤

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

whiz kid, thank you for sharing

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

Is there any way that report should have 3 yrs of data but while opening the reports it only shows the 3 months of data but when we use slicer(year) that should also work ?

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

Very good. Thanks for share Chandeep

@meriamhaq123 13 дней назад

Whats a dax for colour just "orange" cant work

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

These are awesome tricks, thanks for bringing it together. However, I came across one issue when highlighting the rows from slicer selections. Problem is when rows are selected they get highlighted including multiple selections; however when nothing is selected in slicer, it acts like all is selected and highlights everything, which I don't want. If nothing is selected in slicer, it should not highlight anything. How can I do it? Thank you.

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

IF( ISBLANK([SlicerSelection]), // Check if no slicer selection is made BLANK(), // Return blank if no selection // Your original highlighting logic here if a selection is made )

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

@@crownambassador1 Thank you for your reply however I didn't understand how to do it. Here is my code; Highlight rows selected = var check= COUNTROWS( FILTER('Dashboard Dataset', SELECTEDVALUE(Locations[Location]) IN VALUES('Locations disconnected'[Location]) )) RETURN IF(check >=1,"yellow") So, where do I check if isblank(), can you please provide the full code on to this. Thank you again.

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

@@pthapa55 check >=1 and blank . Two check conditions , try that