7 Tips & Tricks for Stunning Power BI Reports!
Vložit
- čas přidán 3. 08. 2024
- Hi everybody! Parker here. Check out this webinar that I recently gave showcasing 7 Power BI tips and tricks that you should add to your Power BI dashboards and reports. These tricks include bookmarks, drillthrough, hierarchies, dynamic measures, forecasting, row-level security (RLS), and subscriptions.
Professional Power BI Services:
bielite.com
To enroll in my introductory or advanced Power BI courses:
training.bielite.com/
Connect with me on Twitter!
/ powerbielite - Věda a technologie
Tip-1 : Hiding filter pane 1:50
Tip-2 : Drillthrough 9:22
Tip-3 : Hierarchies 14:44
Tip-4 : Dynamic Metrics 20:27
Tip-5 : Forecasting 28:38
Tip-6 : Row level security 36:18
Tip-7 : Email subscriptions 40:03
Very helpful, Mouli. Thanks!
@@BIElite
Welcome bro 😎
you forgot 13:28 - channelling of Trump
Good to see all topics covered in single video, Thanks a ton Parker for walking us thru the report with tips & tricks.
No problem, manish!
I love your video. Thanks for making it available to us :)
Many useful features in a single tutorial.Good job
Thank you!
well done for clear, concise summary of useful power bi tips thank you
Thanks for watching!
Great video! Thanks for sharing tips! I was looking some of them for long time. Thank you.
Thank you so much for this video.
Great video, as always. Thanks a ton.
Most helpful and simple tricks, thank you!!
Thank you for watching, Harish!
Wonderful and relevant tips.
Hi, great video! quick question about dynamic metrics, is it possible to add different units to each of the selections?
Very well explained, thanks.
Hey Parker,
Great webinar.
Can you show how to implement RLS on Power BI report server?
Moving to Power BI from Tableau. Power BI makes so much more sense tbh
Hello!
Your videos is amazing! Could you create a video teaching us how to create "First Pass Yield" chart on Power BI?
Great video mate! I learned a lot, thank you!
Very informative, Thank you so much
ausgezeichnete Arbeit! Vielen dank!
Thank you, I already use more or less all these tips and tricks because I followed all your previous videos and this is just perfect! Thank you for all you do for the community ;)
Thanks for watching, Jonathan! I really appreciate comments like this
Great video, as always.! Thank you! Quick question - when I hide a visual for bookmarks, the filters reset to the original state. Do you know why this may be happening?
Very helpful. Great examples.
Thank Justin!
Loved it! Thanks for sharing!
No problem!!
Hi Parker:
Great tips have you resume here!
Thanks for sharing this great material!
great video! thanks for sharing tips! Is there downloadible workbook available for reference?
Thank you
Thanks for watching!
good presentation clear info i like your videos !!
Thank you very much!
Terrific video, Parker!
Thank you Kenneth!
Hey, is there a way to have a slicer with 2 values as one button which changes the table value and the name dynamic? (Imagine 28:50 only having Profit and Revenue and to only change between those 2 with only 1 button)
U rox!!! Pleased can u share a complete learning part for person that wants to be a business intelligence specialist with Power bi? I started with learning about databases reading database design for mere mortals.
Hi Awesome tips, Thanks for sharing, is it possible to share the pbix file to learn more. Many Thanks
Thanks!
And thank you for watching!
Great video.
Apologies if it has been asked before - which map visual are you using that sits under the country bar chart? I can't seem to replicate it from the choices available (and none of the ones available are as snappy to use as this appears)
I have the same question!
Can we apply the same features such has dynamic values of cost, revenue and quantity in the current report showed by you, for Year to Day level
Can you explain how to pull values from different columns in a second table based on the values from a column in the first table..
Awesome!!👍👍
Thanks Shashikant!
I noticed on your visuals you dont see the top band that shows the filter icon or three dots. Is that possible to turn on and off?
When forecasting (out of box model) with data that goes back years, I put 12 months and 365 Point(s) for 1yr forecast and 1 month and 365 Point(s) for 1mth forecast. Every single date needs a value to perform this or it errors out. So any days with no counts need to be amended with a value of at least 1 (which is easy cos we always use a blank calendar in our models, don't we ?)
So 365 days forecast = 365 days with at least 1 counted in null fields across 12 months or 1 month (or 3mths for Qtr if you are bothered).
For the dynamic slicer, how would you format the code so the quantity is in thousands and the revenue is in currency?
Nice one! I like the SelectedMetric, but I can't seem to find where to change the (number)formatting for the selected metric.
Zd
Did you find out how to do this?
And will it change the multiple visuals at the same time in terms of look, let take a situation where I have 4 Bar charts having year to day level hierarchy. How we can achieve the functionality if will drill down to next hierarchy for one chart it supposed to drill down to same hierarchy level for other charts also
This webinar is awesome! How does become a certified PowerBI professional
Thanks! To become certified in Power BI, you must take the DA-100 exam. We have a DA-100 Prep Course that covers every topic tested on the exam: training.bielite.com/courses/da-100-exam-prep-power-bi-certification/
Hey, at the top of the report there is a visual which allows you to chose the start and end date. Can you tell me what that visual is exactly and a source to learn how to use it?
Very Helpful.Could you please share your Pbix file.
Thank you -0 very helpful
Great Video. Would you be so kind to share where one might find the pbix file or dataset used to build this?
Is there anywhere I can get a PDF/Word file of all the menu options in PowerBi? I love the product but there are so many little icons, toggles and suboptions that I'd love a copy of them printed out! (ps. Thanks, great video!)
Nice
Thanks Andrew!
thanks for the video, can i have your dataset ? thanks
Hi.. Great Visuals.. Can I get a copy of this PBIX file..
I would like to know, how you do this map and bars. Do you have any video or tutorial ?
Hi Wellington, I don’t have a tutorial on this, but it’s a simple bar chart overplayed over a map. Not much more than that! It works here because the data kind of leaves a nice area for an extra chart.
maybe a little late but 1st watch this on how to get shape maps czcams.com/video/YV6y1pX0-hg/video.html and then look up how you can conditionally format your bar charts chandoo.org/wp/conditionally-format-visuals-in-power-bi/ . Finally you only have to arrange the two visualizations, good luck!
Can you please let me know the DAX for counting total staff number at on particular point in time. I have employee data in which date of joining is since 1974 to 2021 is there any way if I select 2019 then the total staff headcount show total staff who were present in 2019 whether or not they joined in 2019 in other words a cumulative total of staff whose date of joining is 2019 and backwards?
what visual is that combined bar and geo setup ?
How to compile power BI dashboard without publish?
Hi Parker. I'm looking for online tutorials. Please let me know how to get in touch with you, in case you are available to give online tutorial. Thank you.
You ever need a kidney, I have one spare for you.
xxx
Thanks!