Author: Belinda Allen

Belinda Allen (Microsoft MVP) is both a Microsoft Certified Professional for Dynamics GP (MCP) and a Microsoft Certified Trainer (MCT). She is also the co-founder of Smith & Allen Consulting, Inc. (www.saci.com), a business management software consulting firm for over 24 years. Belinda began implementing ERP systems so long ago that Windows was not an operating system, but an application. Larger businesses used old Main Frames with monitors that were Green and Black and smaller business did accounting by hand. Having seen the evolution that has taken place over the years from pieces of paper to analytics, Belinda still gets excited every time she helps a business improve. Belinda is also well known for her Blog www.BelindaTheGPcsi.com. Her blog is about sharing really useful information about the product quickly and succinctly. She has earned the nickname GP CSI because she excels at reviewing GP problems and figuring what went wrong and why. With followers all over the Globe she is able to share knowledge and achieve her mission: “To Improve the Lives and Business Success of my Followers.” In her time off, Belinda enjoys sailing, woodturning, crochet/knitting, sewing/quilting, reading and playing the ukulele (Belinda often participates in Ukulele Jams in NYC.)

Formatting the Matrix Visual Microsoft Power BI

Tiny Tips I love using PivotTables in Microsoft Excel.  When I use them, I always change them to Tabular and remove Subtotals to make them easier to read.  The Matrix visual in Microsoft Power BI is like the Excel PivotTable.  In this Tiny Tip video, I will show you how to make it tabular and remove subtotals.

by @MsBelindaAllen

Adding the Last Refresh Date in Microsoft Power BI (Tiny Tip)

Tiny Tips
by @MsBelindaAllen

 

In this TINY Video, I will add the last date and time the data in Microsoft Power BI was refreshed.  Old data is bad data!  This is an easy way to make sure you are looking at a good data!

Adding multiple Trend Lines in Microsoft Power BI (Tiny Tip)

Tiny Tips
by @MsBelindaAllen

In this TINY Video, I will add a trend line to my clustered column chart visual in Microsoft Power BI.  Since my visual has 3 columns in each cluster (Legend), I want to have 3 separate trend lines so I can compare the trends of each value in the legend using the same x and y axis.  This 2-minute video shows how to do this!

Underlying data in Microsoft Power BI Visuals

Some visuals provide the report consumer with the ability to “Drill Down” to the underlying data, i.e. the individual records or rows in the dataset in Microsoft Power BI.  In this video, I’ll show you this very feature in a Clustered Column Chart.

Continue reading Underlying data in Microsoft Power BI Visuals

Using DAX Measures across multiple Queries in Microsoft Power BI

 

In this Video, I’ll create a DAX (Data Analysis eXpression) Measure.  This measure creates the Salesperson Commission amount.  To achieve this, I’ll have to multiply two fields together that reside in different queries.

Continue reading Using DAX Measures across multiple Queries in Microsoft Power BI

Using DAX Measures that Counts the number of Invoices in Microsoft Power BI

In this Video, I’ll create a DAX (Data Analysis eXpression) Measure.  This measure will be used to count the number of Invoices.  The same measure will show the number of invoices for each Customer and the numbers of invoices for which each item appears.

Continue reading Using DAX Measures that Counts the number of Invoices in Microsoft Power BI

Making Tooltips easier to read in Microsoft Power BI

In this video, I’ll show you how to format Tooltips in a Microsoft Power BI visual to make them easier on the eyes.  The default of white letters on a black background can be difficult to read.  This 2-minute video will show you simple changes that make tooltips more powerful!

Continue reading Making Tooltips easier to read in Microsoft Power BI