Power BI Hidden Tricks and useful hacks

[@erikvanhurck]

This is just great! I've been using Power BI for quite a while now, but your "moving pages" tip earned you an additional like on the video :-) love it!

[@AccessAnalytic]

Cheers Erik

[@andrewsinha2785]

Essential data, no information, no insights....Thanks Wyn.

[@AccessAnalytic]

?

[@benbell7641]

Custom format 🤯. Thank you!

[@AccessAnalytic]

You’re welcome Ben

[@datadragyn]

That pie chart trigger is such a great tip and I look forward to learning about the gif part 🙂

[@AccessAnalytic]

Glad you liked it Amy

[@FredericLEGUEN-Excel]

Hi Wyn, I didn't know you can apply your custom format by double-clicking on the format number field. Great tips 👏👏

[@AccessAnalytic]

It’s a very hidden one Frédéric

[@IvanCortinas_ES]

Excellent Wyn. Always learning. Waiting for the Power Query tutorial. Thank you very much.

[@AccessAnalytic]

Cheers Iván

[@brianjulius6401]

Wyn - Whoa! A legit use for pie charts. Now I might have to restore those on my visualization pane...

[@AccessAnalytic]

Hah!

[@tacijjola]

Useful stuff! Thanks very much 👍

[@AccessAnalytic]

You're welcome Jola

[@SouthernGroove]

Great Info thanks much!

[@AccessAnalytic]

You're welcome Jeff

[@kebincui]

Very good tips; Thank you Wyn

[@AccessAnalytic]

You’re welcome Kebin

[@tlee7028]

Thank you!

[@AccessAnalytic]

You’re welcome

[@RambergJE]

Great as usual. Can't get the multiple sorting to work by pressing Shift? If it works, it's huge, been frustrated with sorting. And, let's wish for moving pages to another pbix that shares the same dataset. Great when your report becomes too big and you want to break it up into thin reports,

[@AccessAnalytic]

Are you trying to sort columns in a Matrix? You can’t do that. Copying a page would be good. Currently closest you get is Ctrl A to select all visuals the copy paste. But filter panel settings etc aren’t picked up ( I don’t think )

[@RambergJE]

@@AccessAnalytic I tried to sort a table, not a matrix. The arrow on the 2nd column shows asc/desc when I shift-click, but column values do not sort. Not being able to sort a matrix is a pain. And move/copy page should work like in Excel.

[@AccessAnalytic]

@@RambergJE That's an odd situation then. Not sure why it won't sort

[@433aziz]

Great tips, thanks

[@AccessAnalytic]

You’re welcome ismail

[@andrewsinha2785]

What I should have said is this is essential data, no more that that this is key information, no more than that this is great insight. Sorry for being cryptic

[@AccessAnalytic]

Ah.. so it was meant to read... Essential data, no.. it's more than that... essential information.... no it's more than that... essential insight.

[@Dev_Bartwal]

This one is very useful 👍👍

[@AccessAnalytic]

Thanks

[@utubeAgape]

Thank you for these! Moving pages will be so much easier with your tip as will moving objects. Sometimes text boxes are a real hassle to move around too! As far as documenting goes, when I am building a test version, I add a Notes page with a text box to list out particular configuration for certain visuals - such as using book marks or conditional formatting. It helps when I am working on several projects and later have to go back to the test pbix file to make changes before finalizing. (I hide the Notes page so that when I publish in My Workspace It can be viewed in meetings for discussion without seeing the Notes.)

[@AccessAnalytic]

I’m a big fan of notes page Irene.. I add a couple to my template file so it’s there whenever I create a new report

[@dynamics9000]

"Formal education will make you a living; self-education will make you a fortune." - Jim Rohn, This quote helped me to grow and hope it helps you too, a fellow creator

[@AccessAnalytic]

😀

[@AgulloBernat]

New intro music!

[@AccessAnalytic]

A few months old but yes 😃

[@gxsoft]

Hi Wyn, Excellent. I was impressed by the good and simple tips, but also by the elegant presentation. Very good taste. Congratulations, Could you tell me what editing tool you use? Thank you very much, gab Rio Cuarto Argentina, @gxsoft

[@AccessAnalytic]

Thanks Gab, it’s Camtasia