⬇ 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/
@pawewrona9749
25 күн бұрын
I know it's a demo focusing on different things but passing entire table as an argument for FILTER function is making me answer ton of questions on the report performance.
@ПавелГорюнов-п3в
5 ай бұрын
Awersome. It's really nice tutorial. It's helped my today on my work )
@Lyriks_
5 ай бұрын
IMO Chandeep is one of the few excel professionnal that is really fluent in DAX, M and excel language.. MVP in the making 🚀
@hariprasad289
5 ай бұрын
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.
@mirrrvelll5164
5 ай бұрын
Great tricks!
@RumiAnalytics2024
5 ай бұрын
Guru Bosss
@suchandabhattacharjee8356
5 ай бұрын
👌 ❤❤
@meriamhaq123
3 ай бұрын
Whats a dax for colour just "orange" cant work
@unnikrishnansanthosh
5 ай бұрын
whiz kid, thank you for sharing
@karanvirsingh7389
19 күн бұрын
Bro i started from scratch and due to financial issues i could not learn from any online paid courses or offline institutions…but your videos have bought a new hope to my life. Truely an inspiration you are . Love you paaji ❤️
@namangarg7023
Ай бұрын
Second solution was very good to know in an easy manner..first was done in recent project of mine..tks goodly ji
@snjpverma
5 ай бұрын
Cartoon jaise mu kyu banaya ho bhai? Subscribers dar ke bhaag jayenge.
@rahulwankhede8228
4 ай бұрын
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 ?
@mohdzohairrizvi4377
4 ай бұрын
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 ?
@kuldippandey9672
Ай бұрын
@goodly how can we sort the values in slicer - custom order
@datareggibi
5 ай бұрын
Very good. Thanks for share Chandeep
@rauljimenez5485
5 ай бұрын
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
5 ай бұрын
Thanks for improvising
@TheKuruamparambatta
5 ай бұрын
Loved the hierarchical measure..... Will definitely use that in grouping the measures in future projects 👍🙏
@raymondmcgaw4478
5 ай бұрын
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" (
@Rajkumar-kj1vx
5 ай бұрын
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"?
@laurentmarc1928
5 ай бұрын
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 🙂
@brightonalbert3237
5 ай бұрын
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.
@emmanuelapalowo5744
5 ай бұрын
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
@MalinaC
5 ай бұрын
Awesome 🤩! Thank you for the video!
@IvanCortinas_ES
5 ай бұрын
Tremendous tutorial. Very good. Thanks Chandeep.
@megabuilds3007
5 ай бұрын
Awesome tricks. Thank you.
@gennarocimmino
5 ай бұрын
a big, big, big THANKS for shared tutorial :)
@Arkronis80
5 ай бұрын
The hierarchical method to switch on messures is absolutely game changing for what i am working on right now. Cant wait to implement it :)
@samirmurali6808
3 ай бұрын
I am addicted to all your videos, your method of presentation and the content is like " too good". Vahe Guru
@mishymoo34
5 ай бұрын
Awesome! Will be looking for ways to apply these tricks!
@kwanhangcheung691
5 ай бұрын
Hi, it is very nice n very good video. Thx very much
@LilLinh
5 ай бұрын
very interesting 🤩🤩
@chrism9037
5 ай бұрын
So awesome, thanks Chandeep!
@learnexcelwithfun4716
5 ай бұрын
Love you Bro, You are just awesome ❤
@pondyanand
5 ай бұрын
you are amazing !.
@josealvesferreira1683
3 ай бұрын
Very good
@ExcelWithChris
5 ай бұрын
You just never stop to amaze me!!!
@rasiksawant7491
5 ай бұрын
Awesome video sir
@denxx6126
5 ай бұрын
Thx… 2. tip I will use
@bulbulahmed3098
5 ай бұрын
Great.
@martyc5674
5 ай бұрын
So good 🎉
@AnilKumar-vi8oe
5 ай бұрын
You are a absolute master man, awesome as always
@anz672
5 ай бұрын
❤
@akshaymagre5261
5 ай бұрын
Mind Blowing Chandeep. . Awesome mann 🤩
@GoodlyChandeep
5 ай бұрын
Thanks Akshay :)
@pthapa55
5 ай бұрын
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
5 ай бұрын
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
5 ай бұрын
@@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
5 ай бұрын
@@pthapa55 check >=1 and blank . Two check conditions , try that
Пікірлер: 51