Havens Consulting
Video by: Reid Havens
Take your Power BI visuals to the next level by applying dynamic positive/negative color formatting to your first-to-last comparison line! This tutorial expands on the previous visual calculation setup by adding conditional color cues to highlight trends at a glance, great for dashboards and storytelling. Tune in to learn more!
Highlight First or Last Value Comparisons in Power BI with Visual Calcs!
Visual Calcs in Power BI
Video by: Reid Havens
Learn how to compare the first or last values in a Power BI chart using visual calculations! In this tutorial, I’ll walk you through adding a dynamic line marker and error bar comparison that highlights the change from beginning to end, perfect for trend visuals and executive summaries.
Profitability is a key metric for any business, as profits can be distributed back to shareholders either directly or indirectly. An income statement—also known as a Profit and Loss (P&L) statement—answers high-level questions such as “What was our net profit last year?” while summarizing key revenue (e.g., product revenue) and expense (e.g., R&D) items.
Unlike static reports, a P&L semantic model provides granular detail, enabling users to explore insights such as “How was R&D spending distributed across projects, fiscal periods, or legal entities?” With a well-structured model, users can analyze financials dynamically through Power BI reports, PivotTables, and Excel formulas.
Chris Barber is a Chartered Accountant (ACMA, CGMA), four-time Microsoft MVP, and author of Income Statement Semantic Models. He runs StarSchema.co.uk and has created popular YouTube videos (100K+ views) and courses (1K+ participants) focused on building Profit and Loss (P&L) reports in Power BI.
Video by: Reid Havens
Learn how to create a chart that always displays the same number of calendar periods, driven by slicer period selection, and regardless of if there is existing data (yet) for a period. This leverages a [DAX] generated table, relationships, and some auto-magic features. Tune in to learn more!
Signup for our mailing list to gain access to Power BI files and templates from the videos. You’ll receive a welcome email with a link and password to the Blog Files page.
Reid Havens’ early love affair with analytics has, over the past decade, turned into an evolution into data visualization and report design in Power BI.
Since then Reid has been writing articles and creating YouTube videos to share the word of BI, helping to inspire the next generation of Business Intelligence enthusiasts.
