7 Power BI hacks that are useful to know!
Vložit
- čas přidán 7. 08. 2024
- It is time for a new round of tips and this time I bring you 7 new tips that will increase your productivity in power bi.
Enjoy! #curbal "powerbi
Here you can download all the pbix files: curbal.com/donwload-center
SUBSCRIBE to learn more about Power and Excel BI!
/ @curbalen
Our PLAYLISTS:
- Join our DAX Fridays! Series: goo.gl/FtUWUX
- Power BI dashboards for beginners: goo.gl/9YzyDP
- Power BI Tips & Tricks: goo.gl/H6kUbP
- Power Bi and Google Analytics: goo.gl/ZNsY8l
☼☼☼☼☼☼☼☼☼☼
POWER BI COURSES:
Want to learn Power BI? How about you take one of our courses? Here you can find the available courses:
curbal.com/courses-overview
☼☼☼☼☼☼☼☼☼☼
ABOUT CURBAL:
Website: www.curbal.com
Contact us: www.curbal.com/contact
************
************
QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
Linkedin ► goo.gl/3VW6Ky
Twitter ► @curbalen, @ruthpozuelo
Facebook ► goo.gl/bME2sB
#POWERBITIPS #CURBAL #POWERBI #MVP
Huuu - Nice! Thank you! #1 still is limited in usability when it comes to scroll bars in the visual when it comes to PDF export. For #7 I like to use the CRTL+mouse wheel to zoom as I'm too lazy to navigate to the tiny zoom bar. Shift and mouse wheel is also nice.
Uh! Thanks for the tip :)
/Ruth
Very good tips Ruth. Of all, conditional formatting tip is very good and useful in real time.Thank you
Very much Interesting ..Thank you so much for sharing this !!
Awesome, thanks for sharing
I loved it. My favorite waa the conditional formating tip.! Thanks!
You welcome :)
/Ruth
So many thanks Ruth.
Got me with the formatting. Brilliant and so useful
🥳🥳
Thanks Ruth! I'm using conditional formatting min max setting all the time, and all the other tips were usefus findings for me. Especially, column sorting and export with names!
Great!!
5 is my favorite. Thanks Ruth!
My pleasure:)
/Ruth
Very interesting to learn these hacks from you. Thank you Ruth.
My pleasure!
/Ruth
Nice tips...thanks 👍🏼
Great tips, I got to know 2 new tips and the one with measures selection was very good. Thanks 🙏🙇
I have used it a few times and when needed it is very useful :)
/Ruth
Thanks Ruth!
Didn’t know #3 Thanks!
Thank you Ruth, super useful I just knew the last one so I learned 6 new tips :)
Glad it was useful!! ;)
/Ruth
Thank you.
Very good tips.
Thanks from Brazil.
:)
/Ruth
Excellent!
Loved tips 6 to sort columns
Geniales estos tips , gracias Ruth. Saludos
Todo un placer compartir:)
/Ruth
conditional formatting tip is very relevant.. thank you.
Very useful trick to avoid hard coding the values :)
/Ruth
Cool Tips !! ❤️
No. 6 is cool for me!
so goooooood!!! Thank you so much Ruth
😊😊😊
/Ruth
Thanks for sharing these tips! Which tool do you use to record your video’s? Really cool that we can see you in front of the screenshare!
I use camtasia and green screen. On my description box I have a link with all the stuff I have to make my videos :)
/Ruth
Selecting the measures all at once is really awesome trick. Thanks ! 👍👍
Glad you liked it!
/Ruth
@@CurbalEN 👍👍
Very helpful.
I got stuck in uploading .XLS file in power bi desktop. Can we upload . XLS file
Thank you Ruth
My pleasure !
/Ruth
Most useful shortcut key for me is Ctrl-F2 which allows to change multiple occurences of a highlighed string while editing a measure.
Thanks for sharing :)
/Ruth
Good!!!!!!
You got me on 6 out of seven - nice job
😅 glad to hear!
/Ruth
If you choose current values does it say what filters are being applied so when you share the PDF People understand what the data is saying? I would also like to learn more about the "Percent" conditional formatting? Is it saying anything less that X% of the values? Or does it take the total values and then say if the value is X% or less of the total than do your color.... It is very confusing. Oh and I didn't know half of these tips!!!! thanks so much!
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?
2:20 select all columns and on the properties tab, display folder field type "_Columns" so that all columns will be in a folder and measures will be accessible more easily
Don’t like that approach, but I know people that do :)
Well surprise surprise.. I knew only 1 of the 7 !!! The one about conditional formatting is great because I too, faffed around entering ridiculous numbers to get the feature to work. Now I don't! Also file export name mega useful for me.. because I do export a lot! Thanks a bundle.
Wonderful!!! Glad It was worth your time :)
/Ruth
Hi Ruth Hope you are doing great
I am trying to create scatter chart in Power BI where i want to showcase the data label also for each country .I think currently this option is not available in Power BI. Customer wants to see the data label in scatter plot for each country by wave wise (it could be quarter 1 & quarter 2 and so on.)
Can we have option to create a dynamic bubble chart in R and show it in Power BI. The main challenge which i am thinking that if we can create also in R, it will not work dynamically while publishing the report in Power BI Pro to other users.
It would be great help if we can make this possible through R and Power BI if we have such feasibility .I will share the data set format with you.
I don’t know if it is possible to do with R, my R skills are limited.
Can you ask in the power bi community?
Thanks!
/Ruth
Tip #3 is much useful
Yey 🎉🎉
/Ruth
Hi, Is there a way to find the local host without an external program such as DAX studio?
Yes, you can find it here:
%LocalAppData%\Microsoft\Power BI Desktop\AnalysisServicesWorkspaces
@@CurbalEN It happens to be empty :(. Do you know why is so? Is there any alternate route?
Mmm maybe they have changed the path? Do you have power bi open when you check the folder?
@@CurbalEN yes I had. I know every time we open the program host changes and that the program needs to be opened
Mmmm maybe with the xmla update they have changed the location. Can you check in the power bi community?
Hi mam,
In PowerBI desktop when I try to save the report it is showing " unable to save document cannot open package because file mode or file access is not valid for the strem."
Can you please help me in this issue mam.
Need more
More you will get!
/Ruth
On tip Nº 7, you CAN actually zoom in and out with the mouse wheel. Just hold the Ctrl key pressed!
Just like in every MS Office software ;)
Had no idea , thanks for sharing!
/Ruth
cool. but I really could not see clearly on tip 3. could write here for us? thanks a lot.
Bad editing, my bad!
Just right click on a table and pick “select all measures” I think is called.
/Ruth
Ruth, thanks a lot. Actually, I figure out this one, but I could not figure out 3. export graphic.
Just turn on the title of the visual before you download.
/Ruth
@@CurbalEN , I did (sent you screenshot), but it can't.
Hi Mam I do have query will you please resolve it... In friend data set there is column name summary ...In.each rows there is some conversation is mention say .
First row - Rachel is very good but Monica is very beautiful .
Second row - Joey is very much talkative .
Thirrd row - Rachel and Joey going for a trip .. and so on .
Now we have found the count of each Character separately how we count it in power Bi ...
EXCEL I have calculate the count by using CountIf(criteria_range,"*Rachel*") but I am unable to count it in power Bi ...
Trick # 5 sorting columns in PQ surprised me !
It is cool :)
/Ruth
Trick # 5, Selecting the column headers in the order you want and then remove other columns will also change the order - another Chris Webb tip
Trick no.3. Your face covers all so I couldn't saw anything that you describe and click.
Sometimes my editing is awful 😢