Insert Custom Subtotals in the Matrix Visual
Creating custom subtotals in the matrix visual.
Links to the best Power BI learning resources the web has to offer.
Some of the best #PowerBI #DAX learning resources online! Thanks to Alex @itsnotaboutthecell for contributing!
Unlocking the potential of data storytelling
I quickly put Business Intelligence to work providing users access to insights and trends. Reducing manual work and giving others 24/7 access to analysis was no doubt a win for … Continue Reading Unlocking the potential of data storytelling
About Story BI
Welcome to Story BI!
Two Hour SQLBI and GIAC by Topic
Two hours of SQLBI and Guy in a Cube!
5 Tips that turn data into direction in Power BI
5 Tips that help turn data into direction.
Using TREATAS to improve profitability reporting
As a distributor, we offer a ‘spend and profitability’ report in Power BI as an added value for our customers. This report serves two purposes: 1. To provide the customer … Continue Reading Using TREATAS to improve profitability reporting
DAX and Evaluation Context Work Together
Excel to Power BI Part 3 – Getting Started with DAX: Concepts and Examples
Learning Evaluation Context Through Calculating Sales Margins
Excel to #PowerBI Part 3 – Getting Started with #DAX: SUMX and CALCULATE
Excel to Power BI Connected Data
This step-by-step blog series covers just enough to get you rolling. Find out how Power BI compliments what you already know and love in Excel!
Excel to Power BI Power Query
If you are an #MSExcel user looking for a 20 minute hands-on demo that will get you started in #PowerBI, check out part 1 of my new blog series “Excel to Power BI”!
Learning from the Power BI Community – Top 10
2020 has been a great year to dive deeper in Power BI and new emerging features and tools. I’ve enjoyed learning from reporting tips, external tools, updated books, more M, … Continue Reading Learning from the Power BI Community – Top 10
Replacing full records based on partial strings in Power Query.
Need to clean up the specific key words within a column of text strings? Check this out!
Improve the Readability of the Matrix Visual.
It’s no surprise that a program aimed at the pivot table loving business user would include a similar visual called the Matrix. The ability to summarize, search, and drill into … Continue Reading Improve the Readability of the Matrix Visual.
The Classic Income Statement and Power BI – Better Together
Create a visual and interactive Income Statement using Power BI
M + DAX = Dynamic report date & time stamp.
I see this question pop up periodically, I thought I’d update the blog with an older LinkedIn post I shared two months ago. In this post I share the M … Continue Reading M + DAX = Dynamic report date & time stamp.
Moving average chart using dynamic measures and custom time intelligence
Line charts in Power BI provide a way to help supplement a sales table with useful trend information. In this post, I’d like to take this a step further, and … Continue Reading Moving average chart using dynamic measures and custom time intelligence
turning data into direction 