7 Power BI hacks that are useful to know!

[@mikelockheed8857]

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.

[@CurbalEN]

Uh! Thanks for the tip :) /Ruth

[@mauriceprice4211]

Got me with the formatting. Brilliant and so useful

[@CurbalEN]

🥳🥳

[@ArgenisChaffardet]

Awesome, thanks for sharing

[@sonetmollick4630]

So many thanks Ruth.

[@NaraMeerammaTrust]

Very good tips Ruth. Of all, conditional formatting tip is very good and useful in real time.Thank you

[@robweb]

Very good tips. Thanks from Brazil.

[@CurbalEN]

:) /Ruth

[@cadurgeshagrawal]

Cool Tips !! ❤️

[@jacquesstander1090]

Excellent!

[@abhijeetghosh27]

Selecting the measures all at once is really awesome trick. Thanks ! 👍👍

[@CurbalEN]

Glad you liked it! /Ruth

[@abhijeetghosh27]

@@CurbalEN 👍👍

[@alenalihovidova7607]

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!

[@CurbalEN]

Great!!

[@joseagundis1]

Geniales estos tips , gracias Ruth. Saludos

[@CurbalEN]

Todo un placer compartir:) /Ruth

[@kapilkumarasamy5059]

Nice tips...thanks 👍🏼

[@kishoreyc]

conditional formatting tip is very relevant.. thank you.

[@CurbalEN]

Very useful trick to avoid hard coding the values :) /Ruth

[@leonardoromero205]

Hi, Is there a way to find the local host without an external program such as DAX studio?

[@CurbalEN]

Yes, you can find it here: %LocalAppData%\Microsoft\Power BI Desktop\AnalysisServicesWorkspaces

[@leonardoromero205]

@@CurbalEN It happens to be empty :(. Do you know why is so? Is there any alternate route?

[@CurbalEN]

Mmm maybe they have changed the path? Do you have power bi open when you check the folder?

[@leonardoromero205]

@@CurbalEN yes I had. I know every time we open the program host changes and that the program needs to be opened

[@CurbalEN]

Mmmm maybe with the xmla update they have changed the location. Can you check in the power bi community?

[@ihebchafai2780]

Thank you Ruth

[@CurbalEN]

My pleasure ! /Ruth

[@riazuddin7493]

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?

[@jelgerbos5196]

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!

[@CurbalEN]

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

[@chandankumar-np9ez]

Very helpful. I got stuck in uploading .XLS file in power bi desktop. Can we upload . XLS file

[@ayobamiologun9184]

Very interesting to learn these hacks from you. Thank you Ruth.

[@CurbalEN]

My pleasure! /Ruth

[@mehdihammadi6145]

Thank you Ruth, super useful I just knew the last one so I learned 6 new tips :)

[@CurbalEN]

Glad it was useful!! ;) /Ruth

[@kadirkkkk]

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

[@CurbalEN]

Don’t like that approach, but I know people that do :)

[@RobertoStaltari]

5 is my favorite. Thanks Ruth!

[@CurbalEN]

My pleasure:) /Ruth

[@pmsocho]

No. 6 is cool for me!

[@uniQue_XL]

Thanks Ruth!

[@bcippitelli]

I loved it. My favorite waa the conditional formating tip.! Thanks!

[@CurbalEN]

You welcome :) /Ruth

[@geert0202]

You got me on 6 out of seven - nice job

[@CurbalEN]

😅 glad to hear! /Ruth

[@PedroCabraldaCamara]

so goooooood!!! Thank you so much Ruth

[@CurbalEN]

😊😊😊 /Ruth

[@abhishekstatus_7]

Very much Interesting ..Thank you so much for sharing this !!

[@mshparber]

Didn’t know #3 Thanks!

[@mathew9665]

Loved tips 6 to sort columns

[@1yyymmmddd]

Most useful shortcut key for me is Ctrl-F2 which allows to change multiple occurences of a highlighed string while editing a measure.

[@CurbalEN]

Thanks for sharing :) /Ruth

[@SaurabhAgrawal32]

Great tips, I got to know 2 new tips and the one with measures selection was very good. Thanks 🙏🙇

[@CurbalEN]

I have used it a few times and when needed it is very useful :) /Ruth

[@SaniGarba]

Thank you.

[@abhishekstatus_7]

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.

[@CurbalEN]

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

[@zaravind4293]

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.

[@noahhadro8213]

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!

[@sajjad5189]

Tip #3 is much useful

[@CurbalEN]

Yey 🎉🎉 /Ruth

[@gagansingh3481]

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 ...

[@Chris_Aguayo]

Good!!!!!!

[@EricaDyson]

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.

[@CurbalEN]

Wonderful!!! Glad It was worth your time :) /Ruth

[@MrAszpic]

On tip Nº 7, you CAN actually zoom in and out with the mouse wheel. Just hold the Ctrl key pressed!

[@MrAszpic]

Just like in every MS Office software ;)

[@CurbalEN]

Had no idea , thanks for sharing! /Ruth

[@feng3625]

cool. but I really could not see clearly on tip 3. could write here for us? thanks a lot.

[@CurbalEN]

Bad editing, my bad! Just right click on a table and pick “select all measures” I think is called. /Ruth

[@feng3625]

Ruth, thanks a lot. Actually, I figure out this one, but I could not figure out 3. export graphic.

[@CurbalEN]

Just turn on the title of the visual before you download. /Ruth

[@feng3625]

@@CurbalEN , I did (sent you screenshot), but it can't.

[@amarnadhg6896]

Need more

[@CurbalEN]

More you will get! /Ruth

[@gFowmy]

Trick # 5 sorting columns in PQ surprised me !

[@CurbalEN]

It is cool :) /Ruth

[@brendantogher8725]

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

[@thanomnoimoh9299]

Trick no.3. Your face covers all so I couldn't saw anything that you describe and click.

[@CurbalEN]

Sometimes my editing is awful 😢