One little change to improve Power BI slicer performance (BANANAS!!!)
Вставка
- Опубліковано 21 жов 2019
- Patrick shows how you can make one little change to your Power BI slicers to improve report performance. It's bananas!
Guy in a Cube courses: guyinacu.be/courses
********
LET'S CONNECT!
********
-- / guyinacube
-- / awsaxton
-- / patrickdba
-- / guyinacube
-- / guyinacube
-- guyinacube.com
**Gear**
Check out my Tools page - guyinacube.com/tools/ - Наука та технологія
man, love the enthusiasm you always print in your content!!!!
We try our best. Appreciate you noticing. Thanks for watching 👊
The big savings come in the 'Other' category - not only did you save the 45ms of DAX but the 'Other' of three seconds disappears, thats where the time is really saved, yeh? Go back and look at the first perf capture vs the second.
Please keep adding more content relevant to performance improvements. Every single bit of a second we can shave is worth the investment. Also if you can add some examples of best practices on Dax calculations such as countdistinct vs a faster alternate.
Or for example IF statements done right, to save precious time , etc. Thanks!!!
You guys rock as always. Great tip. Keep up the great work.
Appreciate that Matthew! Thanks for watching 👊
Excellent tip! Thanks, Patrick!
Most welcome! Thanks for watching. 👊
Patrick you always amaze me with your tips and tricks, I have a question maybe you would like to do a video about it, I have several separated power bi reports (3 reports) what I want to do is how I can design one pager in one power bi report to include all of these reports in one page (one power bi report) imagine copy paste all these 3 reports into one reports.
Awesome trick
Pretty slick - thank you
Most welcome Randy! Glad you liked it 👊
Woow very nice, thanks!
Are you guys going to make a video of beginner, intermediate, and advanced levels for PowerBI. Starting to learn PowerBI and really like the stuff you guys are doing. I would love to learn how to create the background you guys have and just learn the ways. Import vs DirectQuery and other things. Would love to know if all this is future projects that you're thinking about!!
Thank you and please keep up the good work.
I like performance gain, but imho it's a tradeoff of performance versus user friendliness and intuitiveness, because now it's costing more clicks for the end user and requiring knowledge that as an end user you can click the 'V' thing to display a dropdown.
100% correct. You need to weigh the pros and cons. If the overhead isn't much, but it helps user interaction better. than that is a choice you will need to make.
IN some cases however, regardless of the performance improvement, there is the space savings consideration. A drop-down slicer takes up less space than a list slicer. Again, all a tradef off.
Hi Patrick, thanks for the advice. But, if i don't show the slicers, show then only when i need, using bookmarks, the dax query will run anyway? It will be delayed?
How about if we move all the slicers to the New Filter Pane as a Page Level Filter? It will save space on the page.
Alright, I got to have that mug.
Simple but effective.
Agreed 👊
You did not empty the cache. Do you confirm this is correct?
This is BANANAS, thanks for sharing.
Why did the Other category significantly decreased? My understanding is that is this the time waiting for other visual to render on the page
Any way to load a slicer with a default option select already?
Awesome Video... I know this may not be the right place for this comment but : For some reason a visual filter doesn't seem to be working with an if condition with "HasOneValue" variable. i.e. if i create a filter which uses a variable with saying if "HasOneValue" then Y else N... and ask the visual to filter based on the "HasOneValue" it doesn't work :( . The same thing works for other conditions though... its just the "HasOneValue" that bugs out for some reason or maybe i am just looking at it wrong
Cool ..haha Amazing ✌️
Very amazing! little things can make a big difference.
@@GuyInACube totally
Thanks... But how to avoid showing up unwanted options in slicer.. for eg. "Blank"
Add the slicer field to your page filter and select all then remove blank. Slice will no longer show blank. There might be a smarter way. I'm still pretty new at Power BI
This is 🍌🍌🍌🍌. Handy tip as always, Patrick
hahaha indeed it is. 👊
What are the implications for running slicers through the filters pane?
Filter pane is a way to avoid it as well. Our recommendation is to have the filter pane collapsed by default to get a similar effect.
@@GuyInACube love it
I suppose when the filter pane opens, all the Dax filters activate ( lol, not sure how to describe the phenomena)
That counts as a BANANAS!!! tip. Thanks!!!
hahahah indeed 👊
Where can we get our grubby hands on that Power BI mug?!
We got ours from @MarcLelijveld (twitter handle). We had to go all the way to Europe to get it though.
@@GuyInACube amazing - thank you. Found the shop link here :) teespring.com/stores/data-marc-store
That's a banana split.
hahahaha love it 👊