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.
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!
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)
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!
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 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.
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
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.
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.
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".
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!
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
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.
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!
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!
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??)
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
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
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
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.
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?
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.
"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
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
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
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.
Thanks a lot Patrick. Could you please make a video on how to make parameters as user input. For example when I select a year-month value in slicer it should show that month else currentmonth-1. I created a parameter and modified the M-query. Everything works fine in Desktop. When I entered a value in parameter using Edit Parameter it showed that month's data else default month. But I didn't find any option to display that parameter on report page. Could you please explain how can I achieve that using Parameters. Right now I achieved using DAX, but I want to know how to make the Parameters as user input. We are using Optimized Desktop Jan-2019 version. Thank you once again for the videos. They really helped me a lot.
Well, I don't understand the reasoning to use the selection pane for editing the visual when 99% of visuals/graphs can be edited via the normal paint icon. Please microsoft normalise that.. Thank you for tips,.
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
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?
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.
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 😊👊
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!
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)
Another great video, Patrick. Thanks! Btw, I was nice meeting you and Adam at the Gartner conference in Orlando yesterday.
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!
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 ua-cam.com/video/zHzSBNES6jE/v-deo.html
@@SuperPreshan ua-cam.com/video/zHzSBNES6jE/v-deo.html
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 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 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'm familiar with several of these. Selection pane is nice. I was literally trying to change the font on a KPI card yesterday!
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. :)
The Excel pivot table trick is amazing.
I think you are my new best friend now. Brilliant
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.
Whew I finally knew how to edit the custom table. Thank you Patrick!
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'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!
Great tips big man! Especially the modify table tip.
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
Thanks for the EGPAF shout-out, the great tips, and of course the workshop!
I did not know these five, thanks Patrick!
Patrick, Thanks a lot for this 5 tips. It's really amazing. Greetings from Honduras.
Thanks for sharing Patrick as always great work! I would be interested in the kpi creation
Stay tuned for the video. Thanks for watching!
There's always something new to learn. Thanks man.
Always something! We learn something every day.
God bless you man for going there and being involved in medical projects
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.
Awesome Patrick ! Really cool stuff, thanks for sharing !
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.
Awesome, Thanks Patrick.
Great tips! Thanks!
Please make a video on the KPI. It's an awesome way. Thanks. Your videos are really cool.
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".
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. ua-cam.com/video/sTI__ywg8I8/v-deo.html
@@GuyInACube thank u so much 👌🤗
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!
My biggest question about this is, where can I buy the t-shirts you guys are always wearing?, they're so cool!!
Im from Brazil, and I loved your video. Congratulations.
Appreciate that Daniel! 👊
Thanks a lot for the 1st trick. Didn’t know how to have a matrix looks like a pivot table!
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.
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, 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.
You are awesome!!!
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!
Thanks for tip 2 worked great for me. Love your videos Patrick
I was curious what I didn't know …. maybe next time, I know all these little tricks.
So informative. Thanks Guy in a Cube!
fortunately, I knew all 5, thanks for the video anyway
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. 👊
Yo Patrick, big fan! Didn't know you were here in Lesotho. I'm in Johannesburg, would have driven to meet you.
I knew the #4, and only! Nice video!
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!
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??)
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
Great Patrick ....
Thanks for watching! 👊
Hey Patrick, I'm new to Power BI. Great videos!! Please come to South Africa
Great tips! I didn't know most of these.
Awesome! Thanks for watching! 👊
Great presentation - thank you.
Many thanks! Thanks for watching! 👊
great tips Patrick, loved the map one
Appreciate that! Thanks for watching Muhammad. 👊
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
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.
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
Mozambique...thank you guy in a cube
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
Thanks Patrick
Most welcome! Thanks for watching. 👊
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.
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?
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.
Nice video! greetings from Bolivia!
Like your channel man. Keep it up
Thanks Patrick.
Thanks for watching 👊
Great tips! 5 stars ;)
so funny and useful , thanks
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?
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.
6:50 love your attitude and mindset. Indeed. Not an expert, a lot of knowledge. Knowledge that is still being acquired :D
"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
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
I dont use Power BI, but this video so interesting! Thanks ;)
Nice one Pat! :-)
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.
I knew 4 - thanks for the fifth ;-)
Eagerly waiting for custom KPI 🥂🥂🥂🥂🥂🥂🥂
You and me both! stay tuned! 👊
Enjoyed the training thanks a lot @Patrick #GuyInACube #EGPAF
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.
@ 5:03 the country of Lesutu....LOL! Lesotho Patrick....Lesotho! Good video.
Nope- only knew one. Thanks so much
Thanks a lot Patrick. Could you please make a video on how to make parameters as user input. For example when I select a year-month value in slicer it should show that month else currentmonth-1. I created a parameter and modified the M-query. Everything works fine in Desktop. When I entered a value in parameter using Edit Parameter it showed that month's data else default month. But I didn't find any option to display that parameter on report page. Could you please explain how can I achieve that using Parameters.
Right now I achieved using DAX, but I want to know how to make the Parameters as user input.
We are using Optimized Desktop Jan-2019 version.
Thank you once again for the videos. They really helped me a lot.
Unfortunately, user parameters, at run time, isn't supported at this time.
@@GuyInACube Thanks for the update Patrick. Once again Thank you for making the videos.
Shout out from South Africa
Wonder why changing the data category from City to Place causes the report to show the correct location.
I'm actually more interested in your scraping of Wikipedia for geographical data... That'd be cool.
Simply "Get Data" -> "Web" -> paste "Districts of Lesotho" wikipedia link, then select the table you need. Load it up!
I love you thanks a lot!
Love the shirt
Well, I don't understand the reasoning to use the selection pane for editing the visual when 99% of visuals/graphs can be edited via the normal paint icon. Please microsoft normalise that.. Thank you for tips,.
Yeah Lesotho! I lived there for 6 months!
How did you group all those visuals into a custom KPI ????
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
Will the data be effected if I refresh my data from a query?
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?
Good evening, can you please show me how to print all the information in table -the table complete -
I just love the shirt.