5 things you didn't know about Power BI Desktop
ฝัง
- เผยแพร่เมื่อ 5 มิ.ย. 2024
- Patrick shows you 5 things you didn't know about Power BI Desktop. Some potentially hidden things that may not be obvious and will help you out when creating Power BI reports within Power BI Desktop.
********
LET'S CONNECT!
********
-- / guyinacube
-- / awsaxton
-- / patrickdba
-- / guyinacube
-- / guyinacube
-- guyinacube.com
**Gear**
Check out my Tools page - guyinacube.com/tools/
#PowerBI #PowerBIDesktop #GuyInACube - วิทยาศาสตร์และเทคโนโลยี
![[TH] VCT Masters Shanghai Playoffs DAY 5 // 100T vs PRX | FUT vs TH](http://i.ytimg.com/vi/q75pv359eP4/mqdefault.jpg)
The accuracy of your impersonation of end users wanting the visualisations to look like Excel...is 100% accurate. It made me lol.
You guys are great. I'd love to see more stuff like this where it takes the simplicity of the program to the next level! Thank you for keeping things interesting, too. My wife looked over my shoulder once and commented on how well you made such *ahem* mundane stuff watchable.
3 out of 5 were new to me, making it the best 7 minutes I will have spent all day today! (that's 7 min out of 12-min video) Thanks, Patrick!
Whew I finally knew how to edit the custom table. Thank you Patrick!
Thanks Patrick! I knew 2 through 5. With Query Grouping becoming a staple in all datasets created, just to keep it clean and focused. Looking forward to the Custom KPI Card video!
Another great video, Patrick. Thanks! Btw, I was nice meeting you and Adam at the Gartner conference in Orlando yesterday.
Thank you Patric,. for me all 5 were new and awesome. I use the table for storing all measures. As for the pivot - matrix. I think it will be a matter of time that you can adjust the structure of the matrix in some predefined formats, just like in Excel.
I am working on Power BI from quite some time, but these tips/tricks were amazing. Thanks for sharing this video and all other super-amazing stuff at GuyInaCube.
Thank you Patrick! Number 4 was new to me. Could you please consider creating a video about KPIs? That small pie of yours looked pretty!
I’m new to Power BI, so all of this was new to me. Looking forward to learning more & applying that knowledge! I just subscribed. Thanks for the training!
Awesome! Welcome to the family 😊👊
Like it too much. I knew the 2, 3 and 4 tips but 1 and 5 were new to me. Thank you for sharing Patrick.
I'm familiar with several of these. Selection pane is nice. I was literally trying to change the font on a KPI card yesterday!
Thanks for the EGPAF shout-out, the great tips, and of course the workshop!
Patrick, Thanks a lot for this 5 tips. It's really amazing. Greetings from Honduras.
I knew 2 of the 5. And finally a legitimate use for a pie chart! I would love to see how you created the KPI card.
I've got some issues with Places on Bing maps in PowerBI. I'll try your tips. Hope it will work with my data. Thanks Patrick!
I always wondered how to edit data that you’d manually created inside of Power BI - now I know. Thank you!
It's the little things. :)
I knew 4/5, nice video though! For me the must knows are the quick access toolbar, using search for format fields, the “horizontal slicer”, extract precious in query editor and image charts (table with data bars)
The Excel pivot table trick is amazing.
I think you are my new best friend now. Brilliant
I did not know these five, thanks Patrick!
Good stuffs! There are so many similar small but useful features I found out out of curiosity, out of frustration, accidentally by mis hitting keys and been using those features since then :D
Hello,
Thank you for sharing the tips.
May I ask something? Is there a way that we can hide sheets in power bi like Excel?
Great tips big man! Especially the modify table tip.
Hi Patrick, thanks for sharings your knowledge with us. Something I would like to know from so long... Is there a way to move quickly inside a big table in power BI? You know shortcuts like Ctr+end.
Thanks for sharing Patrick as always great work! I would be interested in the kpi creation
Stay tuned for the video. Thanks for watching!
Thanks for tip 2 worked great for me. Love your videos Patrick
There's always something new to learn. Thanks man.
Always something! We learn something every day.
So informative. Thanks Guy in a Cube!
God bless you man for going there and being involved in medical projects
Hi Patrick, Thanks for this great video. I need a small help.
I don't have the properties filed under the modelling in order to set the map settings. could you please tell me how can I activate it?
Thank
Thanks a lot for the 1st trick. Didn’t know how to have a matrix looks like a pivot table!
Awesome Patrick ! Really cool stuff, thanks for sharing !
Great tips! Thanks!
Hi Patrick. Just starting out with Power BI and I don't see how to filter by a dynamic date like Today or Now. I did find out how to build out a custom date filter but with that you have to actually specify a static date or date range. Got any advice/hacks for this? Thanks!
Hey Patrick, thanks for the tips! I have a map question for you ... I was mapping out units ordered by State and the map threw PR (Puerto Rico) in South America ... do you know of a way to correct that?
great tips Patrick, loved the map one
Appreciate that! Thanks for watching Muhammad. 👊
pivot on matrix is game changer for me. was struggling to do that since long finally your video help me . Cheers !!!.
One Question.
If Matrix/ table has data which is 10 page long, how can you print all 10 pages at once (even pdf would be okay). i can only print current page at a time.
appreciate your response
Can you show/explain how you created the custom KPI card?
Stay tuned for the video. Thanks for watching!
@@GuyInACube Pleasssse show us this bud
@@softia42 th-cam.com/video/zHzSBNES6jE/w-d-xo.html
@@SuperPreshan th-cam.com/video/zHzSBNES6jE/w-d-xo.html
Great stuff. I didn't know the first 3 tips. I knew the last 2. So great that you were able to go to Africa!
Hi Patrick. No doubt you are doing a great job. Any suggestions on how you formatted the pie chart with red and green, I cant see the conditional formatting option in the data colurs. Assuming you created a new custom theme?
Awesome, Thanks Patrick.
Hey Patrick, for countries i use the recommended three-letter abbreviation, but i just found out that the geocoding result depends on the Power BI Desktop application language. Maybe you could ask the Bing Maps Team, why the culture de-de doesn't detect the ISO 3166-3 country letter "RUS".
Great tips! I didn't know most of these.
Awesome! Thanks for watching! 👊
Im from Brazil, and I loved your video. Congratulations.
Appreciate that Daniel! 👊
I knew the #4, and only! Nice video!
Great presentation - thank you.
Many thanks! Thanks for watching! 👊
Hi Patrick, I have noticed that the left new filter Pane is not following the report page scaling, it is too small and not visible, eventhough I have increased to the max the width and text size of the filter pane, (BTW it was perfect before March update, and still after April update)
Please help
Can you demonstrate how to code DAX in power query editor with a table with a column of timestamps and needing to create a duration by subtracting one value from another in the same column, not always able to use an index. Thanks
Wow the stepped layout blew my mindddddd you know what I ended up doing before, I took.....Screen captures from my spreadsheet
Really happy it gave you a different way to do something. Thanks for watching. 👊
Hey Patrick, I'm new to Power BI. Great videos!! Please come to South Africa
Please make a video on the KPI. It's an awesome way. Thanks. Your videos are really cool.
Hi Patrick you and Adam always produce great content ... congrats! Would be possible to show us how we can use the "traffic light" (green, orange, red) depending on a selection? I want to build a status report where I need to report each one of my 4 categories "Overall", "Schedule", "Cost" and "Resource" using the traffic lines. They are not related to number like your example. Thanks
Thank you so much! It is in the works. Stay tuned.
Like your channel man. Keep it up
You are awesome!!!
Great tips! 5 stars ;)
Hello,
I have been stuck with this problem for days... I was tasked with looking at how clients changed groups in a 5 year period. I have made 3 groups: low spending, intermediate spending and high spending. I have client numbers for each one of them and my goal is to see how they move between the groups between a 5 year period. For example in 2014 to 2015 how many people moved from low spending to intermediate, high or stayed the same. I would really appreciate your help with this!
Thank you so much in advance!
I was curious what I didn't know …. maybe next time, I know all these little tricks.
Is it possible to dynamically change field title in a Matrix. Like if select Jan than field name shall change to Jan if i select Feb than it should be Feb else by default it should show current month. Please help.
Enjoyed the training thanks a lot @Patrick #GuyInACube #EGPAF
Patrick - I got excited for a minute there that you had solved one of my issues! Unfortunately no. I have a multi-row card that is auto formatted to 2 decimal points. Which I don’t need. And I don’t have access to the data model as the data is coming from AAS that I don’t have access to. I can’t find a way in the Desktop to format the card to 0 decimal points. Can you help?? Many thanks Mark (maybe your answer to the comment below will also cover multi-row cards??)
I am getting better. this is the first time that I know all the tips. For Create a table from Scratch I prefer to use the function Table.FromRecords and pass a list of records containing my data.
Me too, Daniel! Do you ever use Power Query to generate your #table() statement from a list?
@@FredKaffenberger no, but I'll try.
6:50 love your attitude and mindset. Indeed. Not an expert, a lot of knowledge. Knowledge that is still being acquired :D
Hi there. Mr GuyInACube, did you know that you can select multiple objects in PQ without clicking each of them with CTRL? Just click the first one, hold SHIFT and click the last one. All intermediate items will be included as well.
@ 5:03 the country of Lesutu....LOL! Lesotho Patrick....Lesotho! Good video.
Lately Power Bi has been adding new features into the Power Query editor in Dataflows that I would love to see brought over into Power Bi Desktop
How to visualize SQL geography data type in PBI, anything in the pipeline for that??
Hi Patrick
I'm following your channel you're awesome and thanks for share knowledge with us.
I'm tableau developer I started learning n creating reports in power bi so I want to try weekly challenges is there any Power BI weekly challenges web portal
like ’tableau work out Wednesday site’
Please, tell me
Thanks, advance
My biggest question about this is, where can I buy the t-shirts you guys are always wearing?, they're so cool!!
so funny and useful , thanks
fortunately, I knew all 5, thanks for the video anyway
Hey Patrick, you have made me a BIG fan of you and the unique style of presentation made it more interesting to watch! Thanks friend! By any chance you happen to come to India and especially to Bangalore? Do keep me informed if there is a visit, I would love to be your host here!
I dont use Power BI, but this video so interesting! Thanks ;)
Good evening, can you please show me how to print all the information in table -the table complete -
I love you thanks a lot!
Hi, for the map tip, in the fields section was the "world" icon already coming next to the data. I've worked with location data before but this never happened
You will see the world icon next to the field based on if you have categorized the data.
Nice video! greetings from Bolivia!
Nice one Pat! :-)
Yeah Lesotho! I lived there for 6 months!
Great Patrick ....
Thanks for watching! 👊
it is allways a pleasure to wacth ur videos. I wonder how to get some color when u point with ur mouse? Greeting from Norway :)
That is a feature of Camtasia. I talked about it in this video. th-cam.com/video/sTI__ywg8I8/w-d-xo.html
@@GuyInACube thank u so much 👌🤗
Thanks Patrick
Most welcome! Thanks for watching. 👊
Thanks Patrick.
Thanks for watching 👊
I knew 4 - thanks for the fifth ;-)
Number 5, you mentioned about 'Group', can you please describe a 'Use case' of that grouping? Under what circumstances, we do 'Group' and why? Thanks in advance.
As I understand it, grouping is the equivalent of organizing documents into folders. Once you have a big long list of queries (documents), you would want to be able to navigate that list more quickly, by putting the queries (documents) into folders. What folders you would have would of course depend on the data you have and how it makes sense to YOU to organize it.
I must say number 4 I discovered last year and was surprised how most people I work with were not aware haha
There are so many things though that it is hard for folks to know all of it. Plenty of stuff that we don't know either.
4.5 out of 5 for me but I hate not knowing so, the first one (selection box on custom KPI card) I knew about selection box but I don't know how to make a custom KPI. Do that video please.
Will the data be effected if I refresh my data from a query?
Very Good tips
Glad you found those useful Ali! 👊
Guy in a Cube
Your videos are excellent Patrick. Really enjoy watching them and I learn a lot. Thankyou. Same with your friend’s videos. Excellent team.
Can you explain where the hell did you get that awesome t-shirt? Thanks Patrick , you are great!
They give then out as SWAG at conferences. That's where I got mine.
How did you group all those visuals into a custom KPI ????
"everything in Wikipedia is true" ... Wikipedia is going to use this video as reference :P "Microsoft Certified Data of being TRUE" :'D. As always thanks for the awesome video! I love the way sometimes the content is more technical while sometimes the content speaks to the wider audience! Love it and wish i could double subscribe :D
will you help me to get the data to prepare a dashboard
Love the shirt
Mozambique...thank you guy in a cube
My Question: How to stage data reading from GOOGLE BigQuery to Power BI?
It becomes very expensive while direct query between BigQuery and PBI
2:43 Yes please!
Nice :) Thanks for watching.
Eagerly waiting for custom KPI 🥂🥂🥂🥂🥂🥂🥂
You and me both! stay tuned! 👊
Shout out from South Africa
Wonder why changing the data category from City to Place causes the report to show the correct location.
Nope- only knew one. Thanks so much