Underlying data in Microsoft Power BI Visuals
Aug16

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.   <div… Continue Reading Belinda Allen’s Article on their blog Underlying data in Microsoft Power BI Visuals Some visuals provide the report consumer with the ability to...

Read More
DAX 101 – Wrap up in Microsoft Power BI
Jun24

DAX 101 – Wrap up in Microsoft Power BI

In this (DAX 101) Video series, I’ve created DAX (Data Analysis eXpression) Columns and Measures. In this final video in DAX 101, I’ll put some of the work together to create some new visuals. DAX can be used in Microsoft Power BI, Microsoft PowerPivot, and MDX.  It’s a relatively easy way to model your data. Today’s DAX Expressions: Net Margin = SUM(‘Sales Line Items'[Gross… Continue Reading Belinda Allen’s Article...

Read More
Using DAX Measures across multiple Queries in Microsoft Power BI
Jun17

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. DAX can be used in Microsoft Power BI, Microsoft PowerPivot, and MDX.  It’s a relatively easy way to model your data. Today’s DAX Expression: Commission :=… Continue Reading Belinda Allen’s Article...

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

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. DAX can be used in Microsoft Power BI, Microsoft PowerPivot, and MDX.  It’s a relatively easy way to model your data. Today’s DAX… Continue Reading Belinda Allen’s Article...

Read More
Making Tooltips easier to read in Microsoft Power BI
Jun07

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!

Read More
Using DAX Measures that calculate by row rather than a summary, in Microsoft Power BI
Jun03

Using DAX Measures that calculate by row rather than a summary, in Microsoft Power BI

  In this Video, I’ll create a DAX (Data Analysis eXpression) Measure.  This measure will be used to calculate the total sales price.  Check out this video to see how to create a measure that performs “Aggregation with Iteration”; which is a fancy way of saying DAX needs to calculate the total sales price for each row, then sum it together.  Look at the two examples below and… Continue Reading Belinda Allen’s Article...

Read More
Creating a Conditional Title with DAX in Microsoft Power BI
May31

Creating a Conditional Title with DAX in Microsoft Power BI

In this Video, I’ll use DAX to make a visual Title be conditional based on a selection in a filter, using Microsoft Power BI.

Read More
Tips on using the Matrix Visual in Microsoft Power BI
May29

Tips on using the Matrix Visual in Microsoft Power BI

In this Video, I’ll show you some tips on using the Microsoft Power BI visual.  I’ll build a GL Account Summary Matrix by month.  

Read More
Using Divide in a DAX Measures in Microsoft Power BI
May28

Using Divide in a DAX Measures in Microsoft Power BI

In this Video, I’ll create a DAX (Data Analysis eXpression) function (Divide) to alter a Measure.  DAX can be used in Microsoft Power BI, Microsoft PowerPivot, and MDX.  It’s a relatively easy way to model your data. Today’s DAX Expression: Gross Margin % := DIVIDE(SUM(‘Sales Line Items'[Gross Margin]), SUM(‘Sales Line Items'[Total Sales]), 0)  

Read More
Treemap Bar Chart in Microsoft Power BI
May24

Treemap Bar Chart in Microsoft Power BI

In this video, I’ll use a new custom visual called the Treemap Bar Chart.  It’s like the baby of the Clustered Column Visual and the Treemap Visual.  This was created by MAQ Software. https://maqsoftware.com/

Read More
Line Chart Formatting in Microsoft Power BI
May22

Line Chart Formatting in Microsoft Power BI

 In this video, I demonstrate formatting the Microsoft Power BI Line Chart visual.  

Read More
Creating DAX Measures in Microsoft Power BI
May20

Creating DAX Measures in Microsoft Power BI

In this Video, I’ll create a DAX (Data Analysis eXpression) function to create a Measure.  DAX can be used in Microsoft Power BI, Microsoft PowerPivot, and MDX.  It’s a relatively easy way to model your data. Today’s DAX Expression: Gross Margin % := SUM(‘Sales Line Items'[Gross Margin]) / SUM(‘Sales Line Items'[Total Sales])

Read More
Adding the Fields to a Visual’s Tooltips in Microsoft Power BI
May17

Adding the Fields to a Visual’s Tooltips in Microsoft Power BI

In this Video, I’ll show you how to add fields to the additional information, called “Tooltips”, in a Microsoft Power BI visual.  

Read More
Adding the Q&A Visual in Microsoft Power BI
May15

Adding the Q&A Visual in Microsoft Power BI

In this Video, I’ll add a Q&A Visual to my Microsoft Power BI Desktop Report.  This visual uses Microsoft Bing “Natural Query Language” technology.  This is just a fancy way to say, you ask it a question, and you’ll get an answer back in the form of a visual.  

Read More
Creating DAX Columns in Microsoft Power BI
May13

Creating DAX Columns in Microsoft Power BI

In this Video, I’ll create a DAX (Data Analysis eXpression) function to create a column.  DAX can be used in Microsoft Power BI, Microsoft PowerPivot, and MDX.  It’s a relatively easy way to model your data. Today’s DAX Expression: Gross Margin = ‘Sales Line Items'[Total Sales] – ‘Sales Line Items'[Total Costs]

Read More
Microsoft Excel new Rich Data Types (with Video)
Dec18

Microsoft Excel new Rich Data Types (with Video)

Microsoft Excel Developers have done it again.  They created an amazing new feature called Rich Data Types.  Excel has always been able to recognize Text, Numbers, Errors, etc.  But now?  Now it can recognize Stocks and Geography.  Watch this video to see this cool new feature.     I hope eventually we can develop our own rich data types.  I’d love to be able to just select fields… Continue Reading Belinda...

Read More

Not Your Daddy’s Financial Series

I’m conducting a 2-part series on building and consuming Financial Statement data in Microsoft Power BI called Not your Daddy’s Financials Series.  Feel free to join me! Not your Daddy’s Cash Flow Statement One of the first things we all learn in Business 101 is that Cash is needed to operate a business. We also learned that being Profitable does not mean you have cash in the bank…. Continue Reading Belinda Allen’s...

Read More
Using Relative Date Filtering in Microsoft Power BI
Apr20
Read More
Super cool use of Microsoft Flow
May02
Read More
Read More
Amazon AWS Getting Serious about Analytics — Business Intelligence & Advanced Analytics
Dec08
Read More
I love Microsoft Power BI
Jun24
Read More