08 6210 8500
Refreshing Power BI Reports with a Button Using Power Automate By Simone Palmas Want to keep your Power BI reports up-to-date without waiting for scheduled refreshes? Now, you can manually refresh your report directly from the report interface using Power Automate. Below, Access Analytic team member Simone Palmas has created a step-by-step guide to set [...]
Mastering Dynamic Measure Formatting in Power BI | Part 4: Dynamic Formatting Based on Value Ranges By Melina Louzada You've made it to the final part of our blog series on mastering dynamic measure formatting in Power BI! If you're joining us now, you can catch up with Part 1 here, Part 2 here, and [...]
Mastering Dynamic Measure Formatting in Power BI |Part 3: Using SWITCH/SELECTEDVALUE() for Dynamic Formatting By Melina Louzada Welcome to the third blog in our series on dynamic measure formatting in Power BI! If you haven’t checked out the first two blogs yet, find Part 1 here and Part 2 here. This post will cover using [...]
Mastering Dynamic Measure Formatting in Power BI | Part 2: Dynamic Cell Colour Formatting By Melina Louzada Welcome back to the second part of our series on mastering dynamic measure formatting in Power BI! If you missed Part 1: Flexibility with Visual Level Format String, you can check it out here and download the working file. [...]
Mastering Dynamic Measure Formatting in Power BI | Part 1 - Flexibility with Visual Level Format String By Melina Louzada In the realm of data analysis, the clarity of data presentation is just as crucial as the data itself. Dynamic measure formatting in Power BI enables analysts to tailor data representations to enhance readability and [...]
by Wyn Hopkins Setting up a free Personal Power BI / Fabric Account Do you want to try out the Power BI / Fabric Service (PowerBI.com) or share your portfolio of reports with potential new employers? If you have a PowerBI.com account then you can use the Publish to Web option to share your [...]
by Wyn Hopkins Instant Analysis with Code Interpreter and ChatGPT Take 8 Excel files, write 2 instructions ( 25 words in total ), done…data summarized and charts built! Go to OpenAI.com GPT -4, enable Code Interpreter Write 1 sentence and upload folder of data (do not use sensitive data) Here’s the content of the zipped [...]
by Wyn Hopkins Wordle for Power BI Fans We've updated the Wordle Game for all our Power BI Fans out there. All the words are related to Power BI in some way. Click on the file below to play along! *Word of caution though, the file won't open on iPhones. Download a copy of [...]
by Wyn Hopkins Combining Multiple Files from a Folder How to use Power Query for Excel and Power BI to consolidate multiple files into a single table of data, whether you're using OneDrive , SharePoint or a traditional network folder. As well as showing the basic steps, this video explains the inner workings of the [...]
by Wyn Hopkins Tips & Tricks to using Power BI There are several tricks to using Power BI that aren't always obvious. In this video we show you some of the hidden gems: Create a Measures Table Create Folders for your Measures Drag Measures between Tables (and Folders) Add brackets to negative numbers Consolidate multiple [...]
by Wyn Hopkins Granting access to reports Adding a Power BI report to Teams is straight forward, but granting access can be a challenge. For more on this topic check out our blog article Securely sharing Power BI in Teams
by Wyn Hopkins Brief guide for Power BI users A brief guide for users of Power BI reports. This is a brief guide for users of Power BI reports and not a guide on how to build Power BI reports. This is aimed to help users of Power BI dashboards and reports to understand how [...]
Reach out to the Access Analytic team Monday to Friday on (08) 6210 8500 or submit your contact information and we will be in touch.
Get Ahead of the Game – Book Your Training Now!
Wyn has been awarded MVP status by Microsoft every year since 2017 and is the author of the book “Power BI for the Excel Analyst”. He is known worldwide for sharing his knowledge via the Access Analytic YouTube channel with over 5 million views and 90,000+ subscribers.
He gained his Chartered Accountant qualification at PwC in 2000 and has extensive Business Analyst experience with HBOS and Barclays in the UK plus multinational clients in Perth.
Wyn is skilled in Excel and Power BI development, Power Query automation, management reporting and is an experienced Excel and Power Bl trainer.
Pay my invoice
