Uploaded September 2026 | Updated November 2026, 3 hours ago
👩🏻🎓Do you want to learn Power BI or Pro-Level Excel techniques?
Check out our amazing course at accessanalytic.thinkific.com
The demo Power BI report: app.powerbi.com/view?r=eyJrIjoiZWU3MDU3NWYtNWIxMy00ZjkwLTliYTktZDg2MzkwYTNhNDdmIiwidCI6IjNlMmRlMjgxLTVmY2MtNGU3ZS04Zjc1LTFiZjEzMjczYjQyYSIsImMiOjEwfQ%3D%3D&embedImagePlaceholder=true
🫶🏻 Join the channel to get access to perks:
youtube.com/channel/UCvD2rJJrp0aS48-KCk0eMHQ/join
📗Prefer reading a book to learn then check out "Power BI for the Excel Analyst" by Wyn Hopkins
https://pbi.guide/book/
The team at Access Analytic develop Power BI and Excel solutions for clients in Australia and deliver training around the World.
🌐 https://accessanalytic.com.au/
00:00 Introduction
00:21 Free Power BI Report and Training Resources
00:38 Using Copilot to Build a Dashboard from a SharePoint List
01:23 What Works Best When Prompting Copilot
01:51 First Dashboard Generated Automatically
02:28 Adding Cross-Filtering and More Advanced Charts
03:13 Overlaying Generation Data with Advanced Visual Design
03:49 Creating a Refresh Button and Professional Styling
05:21 Testing Live Data Refresh from SharePoint
06:22 The Big Question: Can We Trust AI-Generated Reports?
07:14 Building Documentation and Data Lineage into the Dashboard
08:10 Why Trust and Validation Still Matter
09:22 Is This the Future of Reporting?
👩🏻🎓Do you want to learn Power BI or Pro-Level Excel techniques?
Check out our amazing course at accessanalytic.thinkific.com
The demo Power BI report: app.powerbi.com/view?r=eyJrIjoiZWU3MDU3NWYtNWIxMy00ZjkwLTliYTktZDg2MzkwYTNhNDdmIiwidCI6IjNlMmRlMjgxLTVmY2MtNGU3ZS04Zjc1LTFiZjEzMjczYjQyYSIsImMiOjEwfQ%3D%3D&embedImagePlaceholder=true
🫶🏻 Join the channel to get access to perks:
youtube.com/channel/UCvD2rJJrp0aS48-KCk0eMHQ/join
📗Prefer reading a book to learn then check out "Power BI for the Excel Analyst" by Wyn Hopkins
https://pbi.guide/book/
The team at Access Analytic develop Power BI and Excel solutions for clients in Australia and deliver training around the World.
🌐 https://accessanalytic.com.au/
00:00 Introduction
00:21 Free Power BI Report and Training Resources
00:38 Using Copilot to Build a Dashboard from a SharePoint List
01:23 What Works Best When Prompting Copilot
01:51 First Dashboard Generated Automatically
02:28 Adding Cross-Filtering and More Advanced Charts
03:13 Overlaying Generation Data with Advanced Visual Design
03:49 Creating a Refresh Button and Professional Styling
05:21 Testing Live Data Refresh from SharePoint
06:22 The Big Question: Can We Trust AI-Generated Reports?
07:14 Building Documentation and Data Lineage into the Dashboard
08:10 Why Trust and Validation Still Matter
09:22 Is This the Future of Reporting?





![Visual Calculations in Power BI
⚡⚡⚡More information in the description below⚡⚡⚡
A first look at Visual Level Calculations in the February 2024 release of Power BI Desktop. Looks very promising, should simplify a lot of common DAX requirements.
⚠️ Formatting Update:
Theres new formatting options as of August 2024
https://youtu.be/a6lI_B58wqQ?si=t0ldp_zZUb5B06Oy
For more format options see https://learn.microsoft.com/en-au/power-bi/create-reports/desktop-custom-format-strings?WT.mc_id=M365-MVP-5002589
If you need to do further calculations on a field AND you want to display it formatted then you will need to create a duplicate unformatted column and hide the original non formatted column that is used in further calculations.
At this stage you also cannot sort by a measure value (the RUNNINGSUM doesnt respect the sort order of a visual if its sorted by a measure) Instead youd need to do something like this
RUNNING TOTAL by Units= SUMX(WINDOW(1, ABS, 0, REL, ROWS, ORDERBY([Units], ASC)), [Units])
The team and I at Access Analytic develop Power BI and Excel solutions for clients in Australia and deliver training around the World. https://accessanalytic.com.au/
Did you know Ive written a book Power BI for the Excel Analyst?
https://pbi.guide/book/
Connect with me
https://wyn.bio.link/ Visual Calculations in Power BI](https://i.ytimg.com/vi/myfQK40yV-I/mqdefault.jpg)




